Home Forums SQL Server 7,2000 Data Corruption 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 RE: 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

  • http://msdn.microsoft.com/en-us/library/aa197950%28v=sql.80%29.aspx

    Script out your jobs first, all logins, backup history, DTS packages, linked servers, server-level permissions. Since you have no backups, there's no other solution here, that corruption's not repairable.

    Afterwards check your IO subsystem and sort out a backup strategy

    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