Sunday, February 19, 2012

DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS

Hi
I ran a DBCC ceckdb with repair data loss
Is there anyway to know what data has been repaired ?
moreover if some data is lost how to find what is lost?
Thanks
Not really. That is why it is so important to have proper backups that you
can restore from so as to minimize data loss.
Andrew J. Kelly
SQL Server MVP
"sa" <anonymous@.discussions.microsoft.com> wrote in message
news:DA2363E3-52A4-43BE-B0C4-9777F88D1F4D@.microsoft.com...
> Hi
> I ran a DBCC ceckdb with repair data loss
> Is there anyway to know what data has been repaired ?
> moreover if some data is lost how to find what is lost?
> Thanks
>
|||Thanks Andrew
|||Hi -
There is no easy way to find this out. If REPAIR_ALLOW_DATA_LOSS is
specified, many errors are "fixed" simply by de-allocating the 8k SQL page.
Thanks
- Surajit
"sa" <anonymous@.discussions.microsoft.com> wrote in message
news:DA2363E3-52A4-43BE-B0C4-9777F88D1F4D@.microsoft.com...
> Hi
> I ran a DBCC ceckdb with repair data loss
> Is there anyway to know what data has been repaired ?
> moreover if some data is lost how to find what is lost?
> Thanks
>

No comments:

Post a Comment