Post reply

ERROR 823: I/0 error (torn page) detected during read at the offset 0x00000000182e000 in file D:\program files\microsoft\SQL server\MSSQL\data\msdbdata.mdf

  • October 3, 2007 at 3:01 am

    #375096

    In our server suddenly we are getting this problem and we couldnt solve this

    ERROR 823: I/0 error (torn page) detected during read at the offset 0x00000000182e000 in file D:\program files\microsoft\SQL server\MSSQL\data\msdbdata.mdf

    thanks in advance

    cheers

    v.kanagaraj kumar

  • October 3, 2007 at 11:43 am

    #738722

    Do you have a backup of msdb?

    There was an I/O error in the past that caused the torn page

    Torn_page_detection:

    This recovery option allows SQL Server to detect incomplete I/O operations caused by power failures or other system outages.

    When set to ON, this option causes a bit to be reversed for each 512-byte sector in an 8-kilobyte (KB) database page when the page is written to disk. If a bit is in the wrong state when the page is later read by SQL Server, the page was written incorrectly; a torn page is detected. Torn pages are usually detected during recovery because any page that was written incorrectly is likely to be read by recovery.

    Although SQL Server database pages are 8 KB, disks perform I/O operations using a 512-byte sector. Therefore, 16 sectors are written per database page. A torn page can occur if the system fails (for example, due to power failure) between the time the operating system writes the first 512-byte sector to disk and the completion of the 8-KB I/O operation. If the first sector of a database page is successfully written before the failure, the database page on disk will appear as updated, although it may not have succeeded.

    Note Using battery-backed disk caches can ensure that data is successfully written to disk or not written at all.

    If a torn page is detected, an I/O error is raised and the connection is killed. If the torn page is detected during recovery, the database is also marked suspect. The database backup should be restored, and any transaction log backups applied, because it is physically inconsistent.

    By default, TORN_PAGE_DETECTION is ON.

  • October 4, 2007 at 3:11 am

    #738974

    AN 823 error suggests a H\W error, so make sure your server guys check the disk out....

    ---------------------------------------------------------------------

  • October 6, 2007 at 9:34 am

    #739791

    Thats right , this is generally due to a hardware error.I would suggest that you run dbcc checkdb to see if the database msdb has errors and correcting it along with check with the hardware guys

  • April 30, 2013 at 10:36 am

    #1611321

    Hi,

    Pls i'm having the same torn page error and i can't seem to solve it. I don't have a backup of my msdb database. This is what i have tried so far as suggested by other people.

    I have ran sqlservr -c -T 3608, moved/renamed the msdbdata.mdf and msdblog.ldf files, run instmsdb to recreate the msdb database. and restarted the server without trace 3608.

    So ple help, this didn't work...

  • April 30, 2013 at 12:09 pm

    #1611360

    Please post new questions in a new thread and include the full output of

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply