Troubleshooting Insufficient Disk Space 

This topic discusses how to respond if you receive either the 9002 or 1105 error message.

During recovery, it is a rare but possible occurrence for the server to require additional log or data space. If additional space is unavailable and either the log or data files cannot grow, the server:

• Reports error message 9002 or 1105 in the Microsoft SQL Server error log.
• Marks the database as RESOURCE PENDING.
• Makes the database inaccessible.

1. Free disk space on any disk drive containing the log file for the related database. Freeing disk space allows the recovery system to grow the log file automatically.
2. Use ALTER DATABASE SET ONLINE to restart the database. For more information, see ALTER DATABASE (Transact-SQL).
3. Free disk space on a different disk drive.
4. Move the transaction log files with an insufficient amount of free disk space to the disk drive in Step 1.
5. Detach and attach the database. For more information, see How to: Move a Database Using Detach and Attach (Transact-SQL).

Managing a Full Transaction Log

Getting SQL Server 2005 Assistance