Asked by:
Event ID: 17053 - Operating system error 112(error not found) encountered

-
Hi there
I have recently installed a new server for a client running SBS2003 R2 with SQLServer 2005.
I noted that the backup failed the SQL Server database on the consistenty check. On checking the event log I see this message as per above.
It reads in the description
c:\data\law\sqldata\data41_Data.MDF:MSSQL_DBCC6:
Operating system error 112(error not found) encountered.
Looking in the error log I see :
Configuration option 'user options' changed from 0 to 0. Run the RECONFIGURE statement to install.
Error: 17053, Severity: 16, State: 1.
C:\Data\LAW\sqldata\data41_Data.MDF:MSSQL_DBCC6: Operating system error 112(error not found) encountered.
DBCC CHECKDB (data41) WITH no_infomsgs executed by NT AUTHORITY\SYSTEM found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 26 seconds.
This is a new server with about 90% of disk space NTFS still available
Any idea's thanks.
Question
All replies
-
Error 112 means there is not enough space on disk. The system uses sparse file and alternate data stream for its dbcc operation. Look like your C:\ drive does not have enough disk space - you need at least the same amount as the original database.
-
-
-
-
Operating system error 112 specifies that there is not further space in the disk. This can be due to the unexpected growth of the tempdb.mdf file. You need to manage the file size of tempdb file.
This can be resolved by running following code:
NET HELPMSG #OS-error-number
Note: replace OS-error-number with the corresponding error number displayed in the message.