English

Error: Failed to paste <feature class> Database space limit is reached

Error Message

Copying and pasting a feature class from a file geodatabase into an enterprise geodatabase fails with the following error.

Error:   
Failed to paste <feature class>
Database space limit is reached [42000:[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Could not allocate space for object <object> in database <database> because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.] [<database>.DBO.<object>]
An image of the error message.

Cause

The error may occur due to one of the following causes:

  • Low disk space on the disk drive.
  • The autogrowth option is disabled or set to a limited file size.

Solution or Workaround

To resolve this issue, use one of the following options before copying and pasting a feature class to an enterprise geodatabase.

Note:
The first two options require consultation with the database administrator (DBA) before changing any settings in SQL Server Management Studio. The DBA decides the file size settings and locations, and whether to enable autogrowth or not.


Ensure the disk drive has sufficient space

In SQL Server Management Studio, ensure the path for the PRIMARY filegroup of the database is set to a drive with sufficient space. The image below shows the path for the PRIMARY filegroup set to drive C:\, with the available space of 76.5 gigabytes (GB).

An image of the Database Properties dialog box.
An image of the drive free space.

Enable autogrowth and set the file size to Unlimited

In SQL Server Management Studio, enable the autogrowth option for the database file and set the maximum file size to Unlimited.

  1. In the Database Properties dialog box, click the ellipsis button of the database file.
An image of the Database Properties window.
  1. Check the checkbox for the Enable Autogrowth option, select Unlimited for the Maximum File Size, and click OK.
An image of the Change Autogrowth dialog box.

Disable the software background geoprocessing

The steps provided describe how to disable ArcMap background geoprocessing.

  1. In ArcMap, click the Geoprocessing tab and click Geoprocessing Options.
  2. Under the Background Processing section, uncheck the checkbox for the Enable option, and click OK. This disables the background geoprocessing.
An image of the Geoprocessing Options dialog box.

Related Information