SQL Server Error 1105 (Severity 17): "Could not allocate space for object '%.*ls' in database '%.*ls' because the '%.*ls' filegroup is full." This error indicates that an operation failed due to insufficient storage space either for:
- A specific filegroup within a database, or - The underlying disk where the data/log files reside. It signifies that SQL Server cannot perform operations like INSERTs, UPDATEs, or;
- index maintenance because it has run out of allocated/available storage. Severity Level 17 suggests a problem at the resource level (e.g., file size limits or disk capacity).
Common Causes:
- Files associated with the affected database have grown to their configured maximum size.
- Insufficient physical disk space available to accommodate further growth.
- Incorrect autogrowth settings prevent logical file increases.
- If the issue occurs in `tempdb`, temporary objects may be consuming all available space.
- User quota restrictions on certain databases.
Steps for Troubleshooting and Resolution
Identify and Verify Database States & File Settings Run this T-SQL script to diagnose which database/filegroup is having problems:
SELECT name AS [Database Name], state_desc AS [State], recovery_model_desc AS [Recovery Model], size*8/1024 AS [Size in MB]
FROM sys.databases;