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.

Torn Pages arise because the page is sent to the hard disk which returns a
receipt back to SQL Server over the bus. Unfortunately it is actually in the
buffer ram of the hard disk and a torn page arises because the first part of
the page is OK but the bottom is rubbish. The real problem is that it will
effectively be some are of table that no longer makes sense. You cannot
find it. There is no way of recreating it or even knowing its the only torn
page. I believe the only answer is to restore from a backup earlier than the
torn page, but remember you still have all the logs back to this backup, so
you apply all those and will have lost no data.

Brian Reincke
Parity Training
London


"Tam OShanter" <tam@oshanter.com> wrote in message
news:9qXmg.185681$ii4.87899@fe08.news.easynews.com ...
> 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.
>