Use Log E to restore data after SqlServer2000 accidentally deletes data

Use log E to restore data after sqlserver2000 accidentally deletes data

A few days ago, because I accidentally deleted the data in the database, there was an old backup data, which could not be used in any way. Later I found it online for a long time and found that I used Log Explorer as a good tool.

First, let's take a look at the interface:

 

Here I use integration verification: click "Connect" to go to the next page.

 

Here, select the database for data recovery and use on-line log (if you back up the file again, you don't need to use this tool, and you can use SQL directly ). Click attach to go to the following interface:

 

At the beginning, I was in the test table.The delete statement is executed,

 

Now, you need to click filter log records in log category E, select the test table in the table filter item, and click Apply"

 

Then return to the view log page as follows:

 

There are two rows of delete_rows! Right-click on the top and select "undo transaction" to generate a SQL statement text recovery. SQL

 

The text content is as follows:

Set identity_insert [DBO]. [test] On

Insert into [DBO]. [test] ([ID], [name]) values (1, 'test ')

Insert into [DBO]. [test] ([ID], [name]) values (2, 'dss ')

Set identity_insert [DBO]. [test] Off

After the query analyzer re-executes the following statements, it can be restored. ---- End