Torn Page error

  • I am getting the following error message while attaching my DB in SQL Server 2000.

     "Error 823:I/O error ( torn page) detected during read at offset 0x000000000026000 in file 'C:\TestFile.MDF.'

     

    I basically, detach the DB from my server and copy that MDF and LDF to another server. Then I Format my first server. Now when i am going to attach my MDF and LDF to second server, it gives me the above error.

    Thanks in advance.

     

    Prashant Thakwanithakwani_prashant@yahoo.co.in

  • Have a look at article "Error 823" in books on line. 

    Based on what this article says, it sounds like the error will most likely have been caused by a disk error. However, this error has corrupted the database and this corruption may not be repairable. 

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

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