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 |
|
rolandsantos
Starting Member
24 Posts |
 Posted - 2008-02-19 : 00:31:24
|
| hi guys,can anyone explain what are torn pages and how to fix this error?BOL suggests to restore from backup. is there any way?thanks in advance... |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-02-19 : 04:41:35
|
| torn page means that there is corruption. the only fix is to restore from backup and play transaction logs to get a full recovery or point-in-time rcovery (if in full archive mode) if you are in simple recovery mode you will lsoe data since the last full or differential backup.torn page usually means hardware problem. check you disk subsystem for issues since this is the usual cause for this type of problem.-ec |
 |
|
|
rolandsantos
Starting Member
24 Posts |
Posted - 2008-02-19 : 04:53:43
|
| thanks a lot, im lucky that i fully recover data from my full and transactional backups.. just hoping if there's a faster method other than restoring.. again, thanks for the advice.. i'll check on my disk.. |
|
|
|
|
|
|
torn page