开发者

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...

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜