How to recover the Delete/update data
Operation Steps
1 db connected to the deleted database
Open Log Explorer Select "File"-> "Attach log File"-> Select server and login mode-> "Connect"-> Select "Database"-> "Attach"
2 View Log
In the dialog box on the left action item, select the Browse item-> "View Log"-> to see the current log record.
3 Recovery data
Right-click a log record, select "Undo Transation"-> "Choose Save file name and path"-> then open the file to Query Analyzer to perform
T-SQL code is okay.
For example, if log is the delete table where ... , the generated file code is the Insert Table ....
two how to recover data after drop table and TRUNCATE TABLE
1 db connected to the deleted database
Operation Ditto
2 Recovery methods
1 Select the "Salvaage dropped/truncate" menu, select the table name in the dialog box on the right, and the droped/trucated date.
In File name, select the location where you want to generate the steps of the INSERT statement, condition choose droped or truncated,
Finally click "Create" will generate INSERT statements, the generated statements into the Query Analyzer inside the execution of it can be
2 Choose "Viewddl Commands" menu-> Select "TRUNCATE TABLE" Action item-> click "Salvage"-> Generate statements-> Query Analyzer execute
Three log Explorer using a few problems
1 complete/differential/log backups of the database
Delete inactive entries in the transaction log if selected during backup
And then use Log Explorer to try to see the log, prompted no log recorders found that match the filter,would your like to view unfiltered data selection Yes will not see just the note Recorded the
If you do not choose to delete the inactive entries in the transaction log
Then use Log Explorer to try to see the log, you can see the original log and do restore
2 modified a part of the data in one of the tables, log Explorer to look at the logs, you can log recovery
3) and then restore the backup, (note: Recovery is disconnected log Explorer from the database, or connected to other data,
Otherwise the database is in use and cannot be recovered)
After the recovery, and then open Log Explorer No log recorders found that match the filter,would your like to view unfiltered data, select Yes will not see just in 2 Modified logging, so recovery cannot be done.
4 Do not use the backup function of SQL backup, bad your log will be destroyed.
The correct backup method is:
Stop the SQL service, copy data files and log files for file backup.
Then start the SQL service and recover the data with Log Explorer