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:
|
|
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:
|
|
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:
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. |