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:
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.
Disable the software background geoprocessing
The steps provided describe how to disable ArcMap background geoprocessing.