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