sqlデータベースdeleteを削除したらどうやって回復しますか？これはネットで探した答えです。オオカミさんの検証をお願いします。
5593 ワード
Log Explorer
Log Explorer 4.1. SQL Server2005
:
http://download.csdn.net/source/620271
:
Log Explorer -> Attach Log File -> SQL Server -> Connect ->
Database Name -> Attach-> Browse-> View Log-> log
: Log Undo Transation-> ->
T-sql
Log delete table where ... , insert table ....
insert table . .
----------------------------------------------------------------------
-- delete/update
----------------------------------------------------------------------
1 Db
log explorer "file"->"attach log file"-> ->"connect"-> " "->"attach"
2
"browse" ->"view log"-> Log
3
log , "undo transation"->" "->
T-sql
: log delete table where ... , insert table ....
----------------------------------------------------------------------
--Log Explorer drop table truncate table
----------------------------------------------------------------------
1 Db
2
1) "salvaage dropped/truncate" , , droped/trucated ,
File Name insert ,condition droped truncated,
"create" insert ,
2) "ViewDDL Commands" -> "truncate table" -> "Salvage"-> ->
----------------------------------------------------------------------
--log explorer
----------------------------------------------------------------------
1) / /
Log explorer , No log recorders found that match the filter，would you like to view unfiltered data yes
Log explorer ，
2) ， Log explorer ，
3) ，( : log explorer ， ，
)
， log explorer No log recorders found that match the filter，would you like to view unfiltered data, yes 2 ， .
4) SQL , .
:
SQL , .
SQL , log explorer