SQL Server error 1105: Filegroup is full, cannot allocate
A data file in the filegroup reached its maximum size or the disk is full, so SQL Server can't allocate space for the table or index.
- Error number
1105- Severity
- 17
- Category
- Memory, log and storage
What it means
Tables and indexes live in filegroups made of one or more data files. When none of the files in the filegroup has free space and none can grow, because autogrowth is off, a MAXSIZE was reached or the disk is full, inserts and index builds fail with 1105. Error 1101 is the same condition when allocating a new page. In SQL Server Express, the 10 GB database size limit causes it too.
Common causes
- Autogrowth disabled, or
MAXSIZEset on the data files. - The disk or volume holding the data files is full.
- SQL Server Express reached its 10 GB per-database limit.
- An index rebuild or large load that temporarily needs much more space.
How to fix it
-
Check file sizes, limits and growth settings.
SELECT name, physical_name, size / 128 AS size_mb, CASE max_size WHEN -1 THEN NULL ELSE max_size / 128 END AS max_mb, growth, is_percent_growth FROM sys.database_files; -
Let the file grow, or raise its limit.
ALTER DATABASE SalesDb MODIFY FILE (NAME = SalesDb_data, MAXSIZE = UNLIMITED, FILEGROWTH = 1GB);
-
Add a file on another volume if the disk is full.
ALTER DATABASE SalesDb ADD FILE (NAME = SalesDb_data2, FILENAME = N'E:\Data\SalesDb_data2.ndf', SIZE = 10GB, FILEGROWTH = 1GB) TO FILEGROUP [PRIMARY];
-
Free space by archiving or purging old data, then rebuild fragmented indexes.
Related errors
1101Could not allocate a new page9002Transaction log for database is full53100PostgreSQL: disk full1114MySQL: The table is fullORA-01653Oracle: unable to extend table in tablespaceSQLITE_FULLSQLite: database or disk is full
More memory, log and storage errors
701Insufficient memory in resource pool8645Timeout waiting for memory resources8623Query processor ran out of resources1204Cannot obtain a LOCK resource
The code and message text are from the Microsoft Database Engine events and errors reference. Browse the full SQL Server error list or search every database error.
Work on SQL Server in SQLly
A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for SQL Server and the other databases you use.