SQL SERVER DB ATTACH ERROR

Question

SQL SERVER DB ATTACH ERROR

Jan Yaqoob-226702

SSC-Addicted

Points: 403
More actions
February 2, 2006 at 12:50 am

#189069

Dear Members / Friends!
My database server crashed and now I am facing problems regarding data recovery.
Windows based Raid/ Mirroring was used for data replication. I had 3 hard drives for data storage/ Replication.
I attached one of the hard disk with a PC and by using a Recovery Software tried to recover data.
The software worked good and listed the lost SQL .mdf and .ldf files, which I saved.
Now whenever I try to attach those files to SQL Server, it generates error,
that the specified file is not a recognized as a valid SQL Server database.
Please help me at this.
I 'll be really grateful.
Thanx + Regardz,
Jan whY? Jan

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

bledu SSChampion Points: 12335 More actions · Answer 1

maybe the files are corrupt. but since you were using disk mirroring you should be able to get your data from the mirror.

Everything you can imagine is real.

Jan Yaqoob-226702 SSC-Addicted Points: 403 More actions · Answer 2

Thanx for the reply,

Isn't there any tool to recover the corrupted SQL Server files?

Please do reply,

Thanx + Regardz,

Jan whY? Jan

bledu SSChampion Points: 12335 More actions · Answer 3

i don't know of any but try googling

Everything you can imagine is real.

Jeff Gray SSChampion Points: 10667 More actions · Answer 4

Jan,

can you tell us if you are using mirroring? You mention 3 drives, which sounds like you are using striping.

If you are mirroring, then the other drive should have a copy of the data file.

If you are using striping (Raid 5 or 0, eg) then you will not be able to recover with just 1 of the drives. If a data recovery program "found" a file on 1 drive of a stripe set, it probably happened to hold the sector(s) where the file directory is located.

good luck.

jg