restoring from mdf

[sqlnerd]

I have this query....

If the logical database got deleted and only the physical data file (.mdf) is available, is it possible to get back the data from the .mdf file by any means and access it through another database name? Pl. help me

 

[SQLBill]

If you have the data file (ie. mydatabase.mdf), you should be able to just ATTACH the database. In Enterprise Manager, expand down to the server/instance and right-click. Click on All Tasks > Attach Database. Provide the proper information in the pop-up window and that should attach your database. Of course, this will give it the original name. Once it's attached you can change the name if you really need to.

-SQLBill

 

[sqlnerd]

Thanks a lot SQLBill... after I posted this query, I searched Books online and got it... and recovered my database... but thanks a lot... it only assures that tek-tips is really really the place to look for the final answer.