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 |
|
ana2000
Starting Member
1 Post |
 Posted - 2010-11-25 : 07:11:45
|
| Hi...I have detached my database and it does not find on my computer now.Even when I search the database mdf file,it does not find.How can I attach my database that not exists anymore? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-11-25 : 07:26:42
|
| Well...there are two obvious questions that come to mind:1. Are you sure you're looking in the right place?2. Do you have backups?If #1 is yes and #2 is no then I guess you have just learned that you should not do stuff without knowing the consequences. Sorry...- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-25 : 07:35:21
|
| Did you detach or delete?>> How can I attach my database that not exists anymore?I think you know the answer to that.Do a search for any .mdf on all disks.Note the name of the file doesn't have to have anything to do with the database.==========================================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. |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-11-25 : 08:56:37
|
| why dont u try with tuneup utilities software |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2010-11-25 : 10:21:23
|
| I'd do a search of all disks looking for any mdf files, otherwise I'd own up and admit I'd messed up.I'd also agree with the above, are you sure you've detached the database and not pressed delete by mistake |
|
|
|
|
|
|
my database is lost