SQL database Delete after delete How to recover, this is the answer online to find. Hope the great God to verify the advice

using Log Explorer to view and recover data log Explorer4.1. Log viewing tool available for SQL Server2005: http://download.csdn.net/source/620271How to use: Open log ExplorerAttach Log File--Select SQL Server server and login method, Connectin database name, select DatabasesAttach-> Left dialog box browse-> View log->you can see that log records the words you want to restore: Right-click Log record Undo transation, select Save file name and path,then open the file to Query Analyzer to execute T-SQL code is available, for example, if log is a delete tablewhere ...      , the generated file code is the Insert Table .... The code for this insert table is then placed in the query parser to execute. You can recover the data.------------------------------------------------------------------------how to recover from being delete/Data for Update----------------------------------------------------------------------1db connected to the deleted database open Log Explorer selection"file"-"Attach log file"Select Server and Login method,"Connect"Select"Database"-"Attach"2View Log Select in the dialog box to the left of the Action project"Browse"Project,"View Log"-you'll see the current log record.3Restore Data Right-click a log record, select"undo Transation"-"Choose Save file name and path"-then open the file to Query Analyzer to execute T-SQL code can be used for example: If log is a delete tablewhere ... , the generated file code is the Insert Table ....------------------------------------------------------------------------Log Explorer recovers data from drop table and TRUNCATE TABLE----------------------------------------------------------------------1db operation connected to deleted database Ibid.2Recovery Method1) Select"salvaage dropped/truncate"menu, select the table name in the right dialog box, and droped/trucated Date, File name Select the location where the INSERT statement will be generated, condition choose whether to droped or truncated, and then click"Create"The INSERT statement is generated, and the generated statement is executed in the Query Analyzer.2) Select"VIEWDDL Commands"menu, select"TRUNCATE TABLE"Action Item, click"Salvage"Build statement,execution in Query Analyzer------------------------------------------------------------------------several issues used by log Explorer----------------------------------------------------------------------1) Make a full/differential databaseLog Backup Backup If you choose to delete the inactive entries in the transaction log and then use Log Explorer to try to read the log, you are prompted no log recorders found that match the filter,would you want to view U nfiltered Data Select Yes to see the record. If you do not choose to delete the inactive entries in the transaction log and then use Log Explorer to try to read the log, you can see the original log and do recovery2) modifies some of the data in one of the tables, and logs are used in Log Explorer for log recovery3then restore the backup, (note: Recovery is to disconnect the log Explorer from the database, or connect to other data, otherwise the database is in use unrecoverable) after the recovery, then open Log Explorer prompt no log recorders found That match the filter,would-to view unfiltered data, select Yes to see the log records you just modified in 2, so you can't recover.4don't back up with SQL backup, and your log will be ruined. The correct backup method is to stop the SQL service, copy the data files and log files for file backup. Then start the SQL service and restore the data with Log Explorer

SQL database Delete after delete How to recover, this is the answer online to find. Hope the great God to verify the advice