Step by Step Process

  1. Go to start menu >> click on all program >> SQL backup recovery. It will show the following screen.
    install
  2. Click on "Load" button to import file >> select the corrupt file & click on "Open" button.
    load button
  3. Now select the Microsoft SQL Server version.
    Note: User can also select "Advance Scan" mode for highly damaged file.
    select file
  4. User can select "Multiple Backup Files Options" to recover multiple files very easily. Other options like Auto detect will select file automatically, Add Files will add files one by one, Add Folder will add whole folder of files and Remove File will delete file from selected list.
    choose version
  5. Select the backup type like full backup then click on Recover button.
    select backup type
  6. It automatically scans and recovers the file and show the detail of recovered file.
    scanning process
  7. After completing the scanning process it will show the preview of recovered file like tables, views, stored procedures etc.
    preview
  8. After previewing the recovered file, click on "Export" button to save the database.
    export
  9. There are two options to export
    SQL Server Database: Directly save on SQL Server database.
    SQL Server Compatible Script: Save on local machine.
    export option
  10. Click on "SQL Server database" and fill the database credentials like server name, database name, user name and password etc.
    database credentials
  11. Click on SQL Server compatible script to export the recover file as a script file.
    sql script
  12. Select the export option
    With only schema: with the help of this option, you can export the only schema of selected database.
    With Schema & Data: It allows you to export the schema as well as data of tables.
    Click on "Export" button.
    select export option
  13. After clicking on export button, it shows the message that you want to export deleted records as well. If Yes then click on "Yes" button otherwise click on "No"
    export deleted records
  14. Select the location where you want to export it.
    select location
  15. After completing the export process it will show the script file location and click on "Finish" button
    close