Hi All,
Quick question...
I've found that a database in our system has encountered a torn page error.

DBCC CheckDB hasn't worked any wonders so we're going to restore from a
backup.

The torn page error began occuring several days ago.

Can we restore successfully from a backup taken after the torn page occured?

Or do we need to go and retrieve the last backup taken prior to the torn
page?


Also, the server is still functioning fine, wondering if we can simple move
the data from one datatase (the one with the torn page) to another new one
on the same machine.

Thanks,

Tam.

Please post the full error message from the error log.

Denny
Tam OShanter wrote: