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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 attaching mdf file

Author  Topic 

subbi39
Starting Member

11 Posts

Posted - 2009-03-19 : 05:50:34
hi all,
good afternoon,i got a small doubt about .mdf file as i want to attach it in 2005 i got an error saying that this file is been used by some other db.but 1 of my databases is been corrupted so i got the only chance is to attach the .mdf file so can any one help me in this regards..
the error code is error:5123
thanks in advance

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-03-19 : 09:15:03
I assume you don't have a backup...?

- Lumbago
Go to Top of Page

BJM RAO
Starting Member

20 Posts

Posted - 2009-03-19 : 10:42:38
Right click on the available database, select Tasks - Restore - FileGroups - Now choose ur options and obtain the file (.mdf) by celecting the radio buton option From Device. Do the same with the .ldf also.
... hope this solves the problem else feel free to aks

tks
Go to Top of Page
   

- Advertisement -