sqlデータベースdeleteを削除したらどうやって回復しますか？これはネットで探した答えです。オオカミさんの検証をお願いします。

  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