Could not allocate space for object ‘%.*ls’%.*ls in database ‘%.*ls’ because the ‘%.*ls’ 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.

Details
Product: SQL Server
Event ID: 1105
Source: MSSQLServer
Version: 9.00.1281.60
Symbolic Name: NO_MORE_SPACE_IN_FG
Message: Could not allocate space for object ‘%.*ls’%.*ls in database ‘%.*ls’ because the ‘%.*ls’ 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.
   
Explanation

No disk space is available in a filegroup.

   
User Action

The following actions may make space available in the filegroup:

  • Turn on autogrow.

  • Add more files to the file group.

  • Free disk space by dropping index or tables that are no longer needed.

  • For more information, see “Troubleshooting Insufficient Data Disk Space” in SQL Server Books Online.

Related:

Leave a Reply