[Warn] Log Explorer for SQL Server 4.2

From: http://www.cnblogs.com/whitney/archive/2008/08/22/1273879.html

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, after half a day in the online software SS, we found that log exlorer for SQL service can display table operation logs. Download, install, and use the software.

Server: 4.2 demo used this time; Database: sql2005; objective: 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> to start data recovery.

(2) confirm the server on which data is to be restored, and enter the login user name and password. If the server is a local computer, use "Windows Authentication" and click <connent> to test the connection.

(3) Select the database where the data to be restored is located and click <attach> to go to the data operation page.

(4 ). after entering the data operation interface, select <view log> from the menu on the left to display operation logs, for example, which table has been added, deleted, or modified, 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). You can export the queried log Content to an XML file. If you want to import the imported XML file to the database, you must write it yourself.CodeAnalyze the XML file.

 

 

 

 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 *. after files such as Bak are restored, the original operation logs may not be queried using logsql, which I have verified.