Post reply

I/O error (torn page)

  • June 24, 2004 at 6:39 am

    #108527

    Hello,

    While processing a cube am getting the following error

    I/O error (torn page) detected during read at offset 0x0000007c644000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\CCD_Data.MDF'.;HY000; Time:6/24/2004 12:42:29 PM

    Hello someone please help me on this issue

     

  • June 28, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • July 1, 2004 at 9:52 am

    #512977

    Torn page errors are given when the SQL engine detects database corruption.  This is usually the result of an incomplete write operation due to a power failure local to the db server (for some reason the db server was not able to finish writing data).

    You can try dbcc checkdb to see if it is able to correct the matter, however this can result in dataloss so generally it is best to restore the last known good backup.

    Best of luck

Viewing 3 posts - 1 through 2 (of 2 total)

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