通过错误我删除了我的数据库是否有任何恢复或回滚它的选项.. [英] By Mistake I have deleted my database Is there any option to restore or rollback it..

问题描述

plz为我提供了任何建议

plz provide me any suggestions

推荐答案

如果您删除了数据库（不是数据库中的数据），则应该从以前的备份中恢复数据库。查看还原数据库备份（SQL Server Management Studio） [ ^ ]



但是为了使恢复成功，你当然需要从数据库仍然存在的时候成功备份。



如果你没有备份恢复的机会很小。您当然可以检查文件是否在回收站中，但即使它们存在，只是将文件放回原位可能无法在所有情况下都有效。

If you have deleted your database (not data inside the database), you should restore the database from a previous backup. Have a look at Restore a Database Backup (SQL Server Management Studio)[^]

However in order for the restore to succeed you of course need a successful backup from the time when the database still existed.

If yuo don't have a backup the chances for restoring are slim. You can of course check if the files are in the Recycle Bin but even if they would be, just placing the files back in-place may not work in all cases.

这篇关于通过错误我删除了我的数据库是否有任何恢复或回滚它的选项..的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！