[Original] Log Explorer for SQL Server 4.2 (1)

 

A few days ago, due to an exception, the database directly deleted the table records without backing up. Afterwards, you need to query the content of the deleted record. Therefore, online softwareSSAfter half a day, I foundLog exlorer for SQL ServiceTable operation logs can be displayed. Download, install, and use this software.Ing.

TheVer: 4.2 demo; Database: sql2005;Purpose: To restore deleted data. Therefore, only the data recovery steps are described.

 

4.2 demoThe interface is highlighted in blue, and the running software is visible:

 

(1). Click<Attach Log File>Start data recovery.

 

 

 

(2) determine the server for data recovery and enter the login user name and password."WindowsAuthentication", Click<Connent>Test the connection.

 

 

(3 ).Select the database where the data to be restored is located, and click<Attach>Enter the data operation interface.

 

 

(4 ).After entering the data operation interface, select<View log>The operation logs can be displayed. For example, if a table has been added, deleted, or modified, all the operation records can be displayed. If the logs have not been cleared for a long time, there will be a lot of these logs. You can use the "filter function" to set conditions for log filtering.

 

 

 

 

You can filter data by time, table, or user.

 

 

(5 ).The queried log content can be exported.XMLFile. ImportedXMLIf you want to transfer files to the database, you need to write them by yourself.CodeAnalysisXMLFile.

 

 

 

 

 

 Note: Be careful when deleting data. Not all data can be recovered. The recovered data operation is normal. 

 

 

PS:

If it is a data backup file *. Bak and other files after recovery, the original operation logs may not be queried using logsql, which I have verified.