Friday, March 9, 2012

Deleted mdf file

I am currently trying to recover a data base that i detached. I have search the computer with *.mdf with out results...
I detached the database from msde 2000 and then installed sql express now when i go to attach the db it is missing, is there away i can recover the db?If you have a backup, you can restore from that. Otherwise, you will need the MDF file at a minimum. The .MDF file is usually the datafile that contains all the database metadata (table lists, Allocation pages, etc.). On a side note the extension MDF is not required. Are there other files that might fit the description?|||i actually don't have a back up... all i know is the file name lis32.mdf. I have searched for that as well, I'm thinking when i installed 2005 it over wrote everything there for msde2000|||It's dead Jim|||RESTORE DATABASE MyDatabase
FROM WormHole = '<insert your path to the space time continium>'
WITH Recovery

Have you checked your recycle bin?|||I have checked the recycle bin...|||It's dead Jim

What he said

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67782|||thanks anyways...

No comments:

Post a Comment