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 |
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
 Posted - 2003-07-08 : 22:05:31
|
| Other than going back to a backup, is there a method for fixing a torn page?-ec |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-07-09 : 03:52:18
|
quote:
Other than going back to a backup, is there a method for fixing a torn page?
Well, we identified which table was producing the error, dropped it and replaced that table. Since then, no more error. However, the wording in the BOL suggests to me that a torn-page has database wide effects, so I think caution would be advised with this approach. It probably has side-effects that we have not noticed.-------Moo. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-07-09 : 06:08:40
|
| You can try fixing with dbcc checkdb.If the database is corrupt then you can set to emergency mode and copy out the data.I wouldn't trust a database after any errors.Restoring a backup is best if you can otherwise copy into another database.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Fixing Torn page error