SQL log file viewing tool (Log Explorer for SQL Server v4.2)

:Http://download.csdn.net/source/2284248

 

1. Log Explorer for SQL Server v4.2.1

I recommend this software.

After installation, register the program (the compressed file has a registration machine)

Open Log Explorer File => attach log file-> Select Server and logon mode-> connect->

Select database> attach> browse> view log> In the left-side dialog box to view the log record.

Click View DDL commands. There are many drop table commands.

Click the "undo" button below to generate the table structure Statement (Create Table ....)

Click the "Salvage" button below to generate the insert Statement (insert into... values ....)

To restore the file, right-click the log record undo transation and choose Save file name and path> open the file and run it in the query analyzer.

T-SQL code.

For example, if log is delete table where..., the generated file code is Insert table ....

Several Problems in Log Explorer

Complete database difference and log backup

Deleted non-active entries in the transaction log are selected during Backup.

When I try to view logs with Log Explorer

Prompt NO log recorders found that match the filter, wocould you like to view unfiltered data

Select Yes and you will not be able to see the record.

If you do not select to delete non-active entries in the transaction log

Log Explorer can be used to view logs.

Detailed method can refer to: http://blog.163.com/liushui19860112@126/blog/static/132373046201052841232492/