How to restore the deleted database from sql server 2008 r2
I deleted a database from SQL Server 2008 R2 by mistake and I need that database to be restored again? I do have backups of 10 days old. But I need that database so that those 10 days of work can be saved and it will affect my carrier as well.
Any ideas or sug开发者_开发技巧gestions or 3rd party tool?
Thanks in advance guys.
See this answer.
Short version: you might be able to recover the deleted .mdf
and .ldf
files if you stop using the server right now and use some sort of undelete utility to recover the physical files. If you able to recover them, then simply re-attach the .mdf
file.
If you aren't able to recover the physical files, the best you can do is restore as recent as your most recent backup, in this case, 10 days...
精彩评论