April 21, 2006 at 9:02 am
In one of my test env, a newly created database(so no old backups available) went into suspect mode this morning....
I tried sp_resetstatus, and restarted the server but the database did not recover, it came up to 37 % recovery and reported the following errors...
------------------
Error: 823, Severity: 24, State: 2
I/O error (torn page) detected during read at offset 0x00000020026000 in file '<Physical file name>'.
Error: 3313, Severity: 21, State: 2
Error while redoing logged operation in database '<DBName>'. Error at log record ID (225:269668:274)..
Error: 3414, Severity: 21, State: 1
Database '<DBName>' (database ID 11) could not recover. Contact Technical Support..
Recovery complete.
-------------------
I am will recreate the DB, but before that I would like to try all possible ways
as how we can recover this DB, just as a learning experience.
April 21, 2006 at 9:09 am
SQL Server is telling you that you have a physical inconsistancy in your data file. You must restore from backup (or rebuild in your case). Read TORN_PAGE_DETECTION in BOL. There are also other threads on SSC discussing this.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply