up vote 2 down vote favorite
share [g+] share [fb]

How to recover the database which is accidently deleted using sql server 2008?

link|improve this question
is this a production database? restore from your backup. stage? well, couldn't you download a new copy from production? – David Hedlund Jul 13 '10 at 6:59
2  
do you have backup? – Serkan Hekimoglu Jul 13 '10 at 6:59
Unless I'm missing something, this isn't about programming, it's a data recovery question, so I'm going to say it belongs on superuser...? – lc. Jul 13 '10 at 6:59
2  
No backups? Oops. – Will A Jul 13 '10 at 7:00
feedback

migrated from stackoverflow.com Jul 13 '10 at 8:47

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 2 down vote

This link answers some common questions just related to this:

SQL SERVER – Restore Database Without or With Backup – Everything About Restore and Backup

The tagline is:

You need complete backup to rollback your changes. If you do not have complete backup you can not revert back. Sorry.

link|improve this answer
Restore database without backup? How misleading is that... you can't... – gbn Jul 13 '10 at 7:05
Hehehe... the author of the post just tried to catch attention. – Leniel Macaferi Jul 13 '10 at 7:06
feedback
up vote 1 down vote

Do you have a backup? If so, restore from this.

If not, you have no further options. The MDF and LDF files are deleted (see DROP DATABASE)

link|improve this answer
2  
You may be able to undelete the files if you're lucky, tho'. Very lucky. – Will A Jul 13 '10 at 7:03
@Will A: And the chances are...? :-) No backup = no restore is the simple answer – gbn Jul 13 '10 at 7:06
feedback

Your Answer

 
or
required, but never shown
discard