Error: Failed to paste <feature class> Database space limit is reached
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>]
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).
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.
- In the Database Properties dialog box, click the ellipsis button of the database file.
- Check the checkbox for the Enable Autogrowth option, select Unlimited for the Maximum File Size, and click OK.
Disable the software background geoprocessing
The steps provided describe how to disable ArcMap background geoprocessing.
- In ArcMap, click the Geoprocessing tab and click Geoprocessing Options.
- Under the Background Processing section, uncheck the checkbox for the Enable option, and click OK. This disables the background geoprocessing.
- ArcMap: Copy and paste data between databases in ArcGIS
- ArcMap: Copying feature datasets, classes, and tables to another geodatabase
- ArcMap: Foreground and background processing
- ArcMap: Background Geoprocessing (64-bit)
- ArcMap: Geodatabases in Microsoft SQL Server