Troubleshooting Error No. 1105 (Insufficient Disk Space on File Group)
You get this error when database was marked suspect during recovery due to insufficient space in file group.
To resolve this issue you can run sp_add_data_file_recover_suspect_db System Stored Procedure.
This SP adds a data file to a file group when recovery cannot complete on a database due to insufficient space on the file group.
After the file is added, this stored procedure turns off the suspect setting and completes the recovery of the database.
Permissions Required to run this SP
You should be a member of the sysadmin fixed server role.
sp_add_data_file_recover_suspect_db [ @dbName= ] ‘database’
, [ @filegroup = ] ‘filegroup_name’
, [ @name = ] ‘logical_file_name’
, [ @filename= ] ‘os_file_name’
, [ @size = ] ‘size’
, [ @maxsize = ] ‘max_size’
, [ @filegrowth = ] ‘growth_increment’
In the following example, database db1 was marked suspect during recovery due to insufficient space (error 1105) in file group fg1.
EXEC sp_add_data_file_recover_suspect_db db1, fg1, file2, ‘C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\db1_file2.mdf’, ‘1MB’;