December 8, 2011 at 5:54 am
Hello. I have a problem with attaching DB.
There is a DB that was detached from the instanse of SQL Server. DB was placed on RAID0. There were nearly nearly 50 tables in DB. After detaching, one of the HDDs of the storage system was broken. Due to this fact I lost one section of the table (single file).
Tell me please, is there any way how can I attach DB without this file? or how can I get data from .ndf files.
Great Thanks!
December 8, 2011 at 6:30 am
did you lose an mdf/ndf or the ldf?
if it was mdf/ndf the only option you have is to restore from backup as you have physically lost data.
if it was the ldf, you could attach all the files and not specify the ldf file for attach and it will create a new one for you
December 8, 2011 at 6:32 am
pavluxaf (12/8/2011)
Hello. I have a problem with attaching DB.There is a DB that was detached from the instanse of SQL Server. DB was placed on RAID0. There were nearly nearly 50 tables in DB. After detaching, one of the HDDs of the storage system was broken. Due to this fact I lost one section of the table (single file).
Tell me please, is there any way how can I attach DB without this file? or how can I get data from .ndf files.
Great Thanks!
If you have lost the mdf file, I think you can't attach that database anyway now. Restore the database from the last good backup (if you have it).
December 8, 2011 at 6:33 am
I'm afraid it will impossible to reattach the database without .mdf or .ndf files.
I hope you have a recent backup available, you will most likely need it.
I'm stating the obvious right now, but RAID 0 is not your best option for database files.
_____________________________________________________
Do not go past the mark you aimed for, but learn when to stop.
You can find me on LinkedIn.
I support The Programmer's Bill of Rights.
MCITP, MCDBA, MCSD
December 8, 2011 at 11:18 am
Great thanks. I lost all data((
I found this programm --- MDF Recovery Tool - Recover MDF Files Data (http://www.bkfrecovery.net/mdf-recovery), but it seems to me that it is gibberish
December 8, 2011 at 11:25 am
Which file did you lose? Was it part of the primary filegroup? (without knowing this, it is impossible to say whether you've lost the DB or not)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply