Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PavluxaF
Starting Member
3 Posts |
 Posted - 2011-12-08 : 07:50:57
|
| 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! |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-12-08 : 08:42:04
|
| Did you do a backup before the detach? I'm guessing not.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-12-08 : 12:05:42
|
| Is the file part of the primary filegroup? Is this Enterprise edition?--Gail ShawSQL Server MVP |
|
|
|
PavluxaF
Starting Member
3 Posts |
Posted - 2011-12-08 : 13:11:15
|
| I did not do backup for this database.No, this file is not a part of primary filegroup.I use MS SQL 2008R2 Enterprise edition |
|
|
|
PavluxaF
Starting Member
3 Posts |
Posted - 2011-12-08 : 13:20:25
|
| 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. What do You think about it |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|
|
help me with db attaching