Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLCode
Posting Yak Master
143 Posts |
 Posted - 2004-04-30 : 10:26:45
|
| We had a torn page detection in one of our restores. It probably was caused due to a bad sector. The table for which this happened is a multi million rows table. Now I thought the dbcc for this table to repair it was a wrong option because it took forever and did not repair it. Even if it would with right options chosen, would not do so without losing data (right?) Is a new restore from good backup only solution to this?Please advice. |
|
|
MuadDBA
628 Posts |
Posted - 2004-04-30 : 10:54:12
|
| I would boot all the users, backup the transaction log, then restore from backup and apply all the transaction logs to get it current again. This might fix your torn page. Run the checkdb again and see. |
 |
|
|
|
|
|
Torn page error