HELP! Corrupt MDF

While on vacation, a customer of ours had their RAID die and nobody seemed
to follow a good recovery process so when I came back all I was left with is
a bad MDF. When I use EM to attach I get Error 823: I/O Error (Bad Page ID)
...
Is there any way to force this to attach?Well I got it attached but I think it's toast because everything I try comes
back with an error of some kind or other.
Of course, backups were not functioning (not my network, I'm just trying to
help :p)
Me-thinks they're screwed.
"Bob Castleman" <nomail@.here> wrote in message
news:euC8AIbeGHA.2188@.TK2MSFTNGP04.phx.gbl...
> While on vacation, a customer of ours had their RAID die and nobody seemed
> to follow a good recovery process so when I came back all I was left with
> is a bad MDF. When I use EM to attach I get Error 823: I/O Error (Bad Page
> ID) ...
> Is there any way to force this to attach?
>|||Hey Bob,
I'm contractor and just got a call similar to your situation. But worse yet
is that the IT dept caused it! They had failed drive in RAID 5 config and
were pulling it to replace with spare but yanked wrong drive which then
failed the array...
There proud of themselves for forcing some kind of rebuild but they got 2
suspect DBs so they thought they'd detach and re-attach. Detach worked,
re-attach is giving the 823 torn page error.
So now they call me. Last back was mid-March. If I can recover any data,
I'd sure like to. How did you get yours to re-attach'
peace - kathy|||Hey Bob,
I'm contractor and just got a call similar to your situation. But worse yet
is that the IT dept caused it! They had failed drive in RAID 5 config and
were pulling it to replace with spare but yanked wrong drive which then
failed the array...
There proud of themselves for forcing some kind of rebuild but they got 2
suspect DBs so they thought they'd detach and re-attach. Detach worked,
re-attach is giving the 823 torn page error.
So now they call me. Last back was mid-March. If I can recover any data,
I'd sure like to. How did you get yours to re-attach'
peace - kathy|||Your best bet is to restore from a backup. If no backup is available, you
can do the following and live with some loss_of_data.
1. create a new empty db with the same name/path.
2. put the db into emergency mode (see alter db for sql2k5, modify
sysdatabases for sql2k)
3. take the db offline (see alter db)
4. swap the db files
5. put the db online (alter db)
6. run dbcc checkdb
-oj
"Kathy_Automation" <KathyAutomation@.discussions.microsoft.com> wrote in
message news:3039CC2A-8DF5-4B2C-A6AD-5016A681DA57@.microsoft.com...
> Hey Bob,
> I'm contractor and just got a call similar to your situation. But worse
> yet
> is that the IT dept caused it! They had failed drive in RAID 5 config and
> were pulling it to replace with spare but yanked wrong drive which then
> failed the array...
> There proud of themselves for forcing some kind of rebuild but they got 2
> suspect DBs so they thought they'd detach and re-attach. Detach worked,
> re-attach is giving the 823 torn page error.
> So now they call me. Last back was mid-March. If I can recover any data,
> I'd sure like to. How did you get yours to re-attach'
> peace - kathy|||Your best bet is to restore from a backup. If no backup is available, you
can do the following and live with some loss_of_data.
1. create a new empty db with the same name/path.
2. put the db into emergency mode (see alter db for sql2k5, modify
sysdatabases for sql2k)
3. take the db offline (see alter db)
4. swap the db files
5. put the db online (alter db)
6. run dbcc checkdb
-oj
"Kathy_Automation" <KathyAutomation@.discussions.microsoft.com> wrote in
message news:3039CC2A-8DF5-4B2C-A6AD-5016A681DA57@.microsoft.com...
> Hey Bob,
> I'm contractor and just got a call similar to your situation. But worse
> yet
> is that the IT dept caused it! They had failed drive in RAID 5 config and
> were pulling it to replace with spare but yanked wrong drive which then
> failed the array...
> There proud of themselves for forcing some kind of rebuild but they got 2
> suspect DBs so they thought they'd detach and re-attach. Detach worked,
> re-attach is giving the 823 torn page error.
> So now they call me. Last back was mid-March. If I can recover any data,
> I'd sure like to. How did you get yours to re-attach'
> peace - kathy