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

Question

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.

Answer 1

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.

 

 

Answer 2

Hi    Thanks for the reply.

 

The server is new with sbs2003 r2 with about 65Gb free space on C:\ so it can't be not enough free space.  The database is not very big..

 

Any more idesa's 

 

Thanks

Stephen

Answer 3

If your sql service is running under any service account then check necessary NTFS privilege for the folder you have mentioned above for that service account.

Answer 4

If the service account can't see/get to the disk (doesn't matter if it's empty or not), it will generate error.

 

Try setting the service account for sqlserver as LocalSystem and try creating the db again.

 

 

Answer 5

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.