Recover data accidentally deleted by SQL Server

Recover data accidentally deleted by SQL Server

Keyword: SQL Server

Method:

1. Download tool (lumigent logtailer4 sqlserver)

2. Registration is required for Installation Considerations. Otherwise, only the two databases pubs and MSDB that come with SQL Server2000 are connected.

3. 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.
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-SQLCodeYou can.

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

 

• Lumigentlogpolicer4sqlserver.rar (3.2 MB)

Lumigentlogpolicer4sqlserver.rar