none
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.

    Wednesday, June 20, 2007 9:55 PM

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.

     

     

    Thursday, June 21, 2007 9:51 AM
    Moderator
  • 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  Smile

     

    Thanks

    Stephen

    Saturday, June 30, 2007 12:49 AM
  • 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.
    Sunday, July 01, 2007 1:49 AM
    Moderator
  • 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.

     

     

    Monday, July 09, 2007 4:12 PM
    Moderator
  • 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.
    Saturday, March 19, 2016 6:42 AM