How to Recover SharePoint Database using SharePoint Recovery Tool

Apply Simple Steps & know how to recover SharePoint database by using marvelous solution name called SharePoint document recovery tool.

1. Open SharePoint recovery software: Go to Start menu » Programs » SharePoint Recovery. . You will see the following initial screen of the SharePoint document recovery tool:
   
   
   
   
2. Now, you have to click on the Browse button to select the corrupted/damaged MDF file. After you click on Browse, you will see the following window from where you will have to browse the MDF file:
   
   
   
   
3. Browse the corrupted/damaged MDF file and click on the Open button. After this, you will be able to see the location path of the selected MDF file as shown below:
   
   
   
   
4. Now, click on the Recover button. As you click " Recover" button, SharePoint recovery tool will start to recover SharePoint database and you will be able to view the status in the prompted window as follows:
   
   
   
   
5. Now, you can see preview all the components of the repaired MDF file like sites, documents, lists, search etc as shown below:
   
   
   
   
6. After previewing the contents after repair SharePoint database, you have to click on the Export button (at the bottom of the window) in order to save the repaired MDF file. On clicking "Export" button, software will display the following screen:
   
   
   
   
7. In the above Window, you can see two Saving Options (SQL Server Database and SQL Server Compatible SQL Scripts). Choose any one option out of the two.
   
   
   • SQL Server Database: If you choose this option, SharePoint file recovery software will save or import the repaired MDF file in an existing SQL server database. If you select this option, you will be asked to provide all the database credentials such as: Server Name, Database Name, Username, Password etc. Then select the tables, views procedure to be saved from the left-bottom panel and finally click on "Save" button.
   • SQL Server Compatible SQL Scripts: If you choose this option, SharePoint database recovery software will save all SQL scripts in a specific folder. Select the tables, views procedure to be saved from the left-bottom pane and finally click on "Save" button.
8. After choosing the "Export To/As" option, click the " Save" button for saving the recovered data. After clicking, you will be asked for saving the deleted records. Click " Yes " if you want to export deleted records as well. Otherwise, click "No" as shown below:
   
   
   
   
9. After clicking "Yes" or "No" software will show the browsing screen as shows below. You have to choose a location where you want to save the recovered SharePoint contents as shown below:
   
   
10. After choosing the saving location, click the "OK" button. As you click the "OK" button, software will start the recovery process and you will be able to see the status as shown below:
    
    
    
    
11. After the completion to recover SharePoint database process, software will prompt you about the completion as follows:
    
    
    
    
12. To Open the Recovered SQL File: Click the Close button and then navigate the location where you had chosen to save the file as shown below: