The database data file has reached its maximum size limit and the disk has no more space. Autogrowth is disabled or set to a fixed maximum that has been reached. An unexpected data volume increase (e.g. audit table runaway, ETL loading too much data) filled the file

Step 1: Check database file sizes and free space: SELECT name, size*8/1024 as size_mb, FILEPROPERTY(name,'SpaceUsed')*8/1024 as used_mb, max_size FROM sys.database_files;. Step 2: Expand the data file or remove the size limit: ALTER DATABASE [yourdb] MODIFY FILE (NAME = yourdb, MAXSIZE = UNLIMITED);. Step 3: Free space by removing unnecessary data: TRUNCATE or DROP old tables, rebuild indexes to reclaim fragmented space: ALTER INDEX ALL ON [table] REBUILD;

Critical severityresource

Power BI Refresh Error:
1105

What does this error mean?

SQL Server cannot allocate a new page in the database — the data file is full and cannot grow further.

Common causes

1The database data file has reached its maximum size limit and the disk has no more space
2Autogrowth is disabled or set to a fixed maximum that has been reached
3An unexpected data volume increase (e.g. audit table runaway, ETL loading too much data) filled the file

How to fix it

1Step 1: Check database file sizes and free space: SELECT name, size*8/1024 as size_mb, FILEPROPERTY(name,'SpaceUsed')*8/1024 as used_mb, max_size FROM sys.database_files;
2Step 2: Expand the data file or remove the size limit: ALTER DATABASE [yourdb] MODIFY FILE (NAME = yourdb, MAXSIZE = UNLIMITED);
3Step 3: Free space by removing unnecessary data: TRUNCATE or DROP old tables, rebuild indexes to reclaim fragmented space: ALTER INDEX ALL ON [table] REBUILD;

Frequently asked questions

How do I enable autogrowth for a SQL Server data file?

ALTER DATABASE [yourdb] MODIFY FILE (NAME = yourdb_data, FILEGROWTH = 512MB); — set a meaningful growth increment (not the default 1MB or 1%) to avoid frequent growth events.

How do I reclaim space from a SQL Server database?

First rebuild indexes (ALTER INDEX ALL ON table REBUILD), then check if empty space can be released: DBCC SHRINKFILE (yourdb_data, target_size_mb); — but avoid frequent shrinks as they cause fragmentation.

Does Azure SQL Database have error 1105?

Yes — Azure SQL has storage limits per service tier. If the database reaches the tier limit, error 1105 appears. Scale up the service tier or use auto-scale (Hyperscale tier) to avoid it.

Official documentation: https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-1105-database-engine-error