Tam OShanter wrote:
> 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.