Monday, February 4, 2008

SQL error 9002 or 1105 - Insufficient Disk Space

When there is no sufficient disk space for the log file or the data file to growth, you will receive either the 9002 or 1105 error message.

If this error happens with normal database update, to solve the problem, free disk space on any disk drive containing the log file or data file for the related database.


If this error happens during database recovery, the database will be marked as RESOURCE PENDING and will be inaccessible. To solve the problem:
1. Free disk space on any disk drive containing the log file for the related database
2. Use ALTER DATABASE SET ONLINE to restart the database