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
 Old Forums
 CLOSED - General SQL Server
 Recovering a deleted database

Author  Topic 

dee-u
Starting Member

14 Posts

Posted - 2006-06-09 : 05:20:18
If I have 'accidentally' deleted the database (including the back-ups) is it possible that I could still salvage any of the files gone? I am hoping you guys could shed light on this regard, thank you so much! BTW, the deletion is done in the EM...

nr
SQLTeam MVY

12543 Posts

Posted - 2006-06-09 : 07:14:10
The files are deleted when you drop the database now.
If you have also deleted all the backups the only way would be to see if windows can recover the files.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-06-13 : 02:01:34
Do the backups go into the recycle bin when that happens?

No chance the files are on tape or somesuch?

Kristen
Go to Top of Page

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-06-13 : 13:55:37
Kristen,

It depends on how big the files were, how they were deleted, and how much was already in the Recycle bin.

Ken
Go to Top of Page

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2006-06-13 : 15:34:23
The database files are deleted when you delete via EM, but if you made backups they should still exist. The prompt you get about deleting backups when deleting a database via EM is only talking about the backup history. Pretty much just deleting records from msdb. Not actual backup files you may have created. If you didn't make any backups... it's simply gone.

Jeff Banschbach, MCDBA
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-06-13 : 16:40:24
"It depends on how big the files were, how they were deleted, and how much was already in the Recycle bin"

I was referring to when the SQL Client Tools delete the backup files, when the DB is dropped.

Kristen
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-06-13 : 16:47:49
The files do not go into the recycle bin when you drop a database.

Tara Kizer
aka tduggan
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-06-13 : 17:32:53
Thanks Tara. Pity though

Kristen
Go to Top of Page

cmdr_skywalker
Posting Yak Master

159 Posts

Posted - 2006-06-13 : 23:36:24
there is still a way, depending on what happended after you drop the database (hoping the sectors were not overwritten).
1. use a file recovery tool. You can find tons in the internet (http://www.google.com/search?q=file+recovery+shareware) or not free (pctools.com, wininternals.com)

2. If the file is still intact, attach the recovered filed.


May the Almighty God bless us all!
Go to Top of Page
   

- Advertisement -