Could not allocate space for object ‘%.*ls’ in database ‘%.*ls’ because the ‘%.*ls’ filegroup is full.

Details
Product: SQL Server
Event ID: 1105
Source: MSSQLServer
Version: 10.0
Component: SQLEngine
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.

   
   
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.

   
   
Version: 9.0
Component: SQLEngine
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.

   
   
Version: 8.0
Component: SQL Engine
Message: Could not allocate space for object ‘%.*ls’ in database ‘%.*ls’ because the ‘%.*ls’ filegroup is full.
   
Explanation

The specified filegroup has run out of free space.

   
User Action

To gain more space, you can free disk space on any disk drive containing a file in the full filegroup, allowing files in the group to grow. Or you can gain space using a data file with the specified database.

Freeing disk space

You can free disk space on your local drive or on another disk drive. To free disk space on another drive:

  1. Move the data files in the filegroup with an insufficient amount of free disk space to a different disk drive.
  2. Detach the database by executing sp_detach_db.
  3. Attach the database by executing sp_attach_db, pointing to the moved files.

Using a data file

Another solution is to add a data file to the specified database using the ADD FILE clause of the ALTER DATABASE statement. Or you can enlarge the data file by using the MODIFY FILE clause of the ALTER DATABASE statement, specifying the SIZE and MAXSIZE syntax.

Related:

Leave a Reply