Software Prerequisite

  • Platinum Class Processor
  • Minimum Memory: 512MB RAM (1GB Recommended)
  • Disk Space: Enough space to store the merged output
  • High-speed internet connection
  • SQL Server:- 2019/ 2017/ 2016/ 2014/ 2012/ 2008 R2/ 2008/ 2005/ 2000

User Interface

Once you download the SysInfo MS SQL Transaction Log Recovery, you will find the interface mentioned below:

User Interface

Software Working

Download and Install the SysInfo SQL Transaction Log Recovery

  • Step 1: Start the SysInfo SQL Transaction Log Recovery Tool as an administrator.
    Step 1
  • Step 2: Browse the files from the system:
    • LDF File:- It allows users to add the LDF file from a PC.
      Step 2
    • MDF File:- It allows users to add the MDF file from a PC.
      Step 2
  • Step 3: Once you browsed the LDF and MDF files in the software, click Next.
    Step 3
  • Step 4: Once the scanning process gets done, you can see your recovered data in the preview pane of the software.
    Step 4
  • Step 5: Select the log files and folders you want to save. You can also preview the SQL file version SQL file collation, and details here.
    Step 5
  • Step 6: Now, click on the Save button to go on the restoration procedure.
    Step 6
  • Step 7: Here, you can choose either of the two options,i.e., Save in SQL Server Database or Save as SQL Script.
    • Save in SQL Server Database:- Under Save in SQL Server Database option, either select Windows Authentication or SQL Server Authentication to save the log file directly to SQL Server Database.
    • Save as SQL Script:- Choose Save as SQL Script option and browse for the location to save recovered log files.

    Step 7
  • Step 8: You can also save the table constraints and enable the operations you want to Save: INSERT, DELETE and UPDATE.
    Step 8
  • Step 9: Date range option to download recovered data within a specific date.
    Step 9
  • Step 10: Click on the Ok button to start the saving process.
    Step 10
  • Step 11: Once the saving process gets completed, you will get a dialogue box showing the successful message. And finally, close the application.
    Step 11

Frequently Asked Questions

What are the different saving options available for saving the recovered SQL transaction log files?

  1. SQL Server:- It allows saving the recovered data directly on the SQL Server.
  2. SQL script:- It allows you to save recovered items into SQL compatible script.

SysInfo Transaction Log Recovery Software supports the recovery of LDF/MDF files created with SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, and 2019 versions.