SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Recovering a deleted database
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

dee-u
Starting Member

14 Posts

Posted - 06/09/2006 :  05:20:18  Show Profile
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

United Kingdom
12543 Posts

Posted - 06/09/2006 :  07:14:10  Show Profile  Visit nr's Homepage
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

United Kingdom
22403 Posts

Posted - 06/13/2006 :  02:01:34  Show Profile
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

USA
391 Posts

Posted - 06/13/2006 :  13:55:37  Show Profile
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

USA
478 Posts

Posted - 06/13/2006 :  15:34:23  Show Profile  Visit efelito's Homepage
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

United Kingdom
22403 Posts

Posted - 06/13/2006 :  16:40:24  Show Profile
"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

USA
36582 Posts

Posted - 06/13/2006 :  16:47:49  Show Profile  Visit tkizer's Homepage
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

United Kingdom
22403 Posts

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

Kristen
Go to Top of Page

cmdr_skywalker
Posting Yak Master

159 Posts

Posted - 06/13/2006 :  23:36:24  Show Profile  Visit cmdr_skywalker's Homepage
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
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000