Sql server 的数据删除回复

昨天一不小心把任务表中的14万条记录给删了！ 

寻遍大江南北，试了两个工具，到底还是没找回来，回滚到上周的备份了，这周的东西没了。

 

通过工具恢复的前提还是有full recovery log，我们这个为了节约空间设置的简单log。

 

所以重要的还是备份。有一个恢复方法是不错的：

 

If you have any full backups prior to the DROP TABLE and the database recovery model is full or bulk logged, the it is pretty easy to restore the table.

1. Backup the transaction log.
2. Create a new database.
3. With SSMS, right click the new database and Tasks->Restore->Database
4. Select "From database:" and choose the original database.
5. Select a date and time prior to the DROP TABLE in "To a point in time"
6. On the "Options" page change the filename in "Restore As" to the new temporary database and check "Overwrite the existing database"
7. Click Ok.

When the restore is done, the database might be displayed with "Restoring" in SSMS. To fix this execute the following in a query window:

Code:

restore database newdbname with recovery