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 |
|
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. |
 |
|
|
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 |
|
|
|
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 |
|
|
|
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 |
|
|
|
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 |
|
|
|
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 Kizeraka tduggan |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-13 : 17:32:53
|
Thanks Tara. Pity though  Kristen |
|
|
|
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! |
|
|
|
|
|
|
|
|
Recovering a deleted database