Re: many problems, fixed?
From: Crimson Tide (crimson_tide_at_myrealbox.com)
Date: 04/27/04
- Next message: Gert-Jan Strik: "Re: Index Performance"
- Previous message: Mark Call: "Database Read-only"
- In reply to: Ryan Sanders: "many problems, fixed?"
- Messages sorted by: [ date ] [ thread ]
Date: 27 Apr 2004 15:05:10 -0700
Can anyone provide any guidance?
Thanks!
Ryan
"Ryan Sanders" <rsanders> wrote in message news:<108nd8uapvjvbb2@corp.supernews.com>...
> Hi All-
>
>
>
> SQL7.0 SP0 NT4. I was brought in to help fix this database, backups are
> there, but corruption has been in the maintenance plan log for over a year.
> I made backup of db and restored as different name on different disk array.
> I ran DBCC CHECKDB on database, it reported 17,000+ consistency errors. I
> next rebuilt indexes and ran CHECKDB again. Dropped errors to 202. Ran
> CHECKDB with repair_rebuild option. This corrected some errors, now I am
> down to 94. Since it was a copy I gave it a shot and ran CHECKDB with
> repair_allow_data_loss option. After this ran, CHECKDB reports 0 errors. I
> have compared row count on corrupt tables before and after the data_loss
> option ran and my row count is the same before and after.
>
>
>
> What else do I need to look at to see what data was loss with the
> repair_data_loss option?
>
>
>
> After ths is correct I will be working with the owner and app vendor to get
> the sql and os at least patched to current levels if not upgraded.
>
>
>
> Thanks!
- Next message: Gert-Jan Strik: "Re: Index Performance"
- Previous message: Mark Call: "Database Read-only"
- In reply to: Ryan Sanders: "many problems, fixed?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
