How to Use SharePoint Server Recovery to restore SharePoint Server data files

• Step 1: Start the SysInfo SharePoint Server Repair Tool as an administrator.
  
• Step 2: Click Open to browse the MDF file path from your system.
  
• Step 3: Now, select the Recovery option as per your requirement:
  1. Complete Database Recovery:- If you choose this option, this will recover all of your data that is stored within the SharePoint Server.
  2. Document Recovery:- If you choose this option, the software recovers SharePoint data and shows them in a tree structure to save.
  
  
• Step 4: Here, we firstly discuss the working of the Complete Database Recovery.
  
• Step 5: Select the Recovery mode as per the level of corruption, either Standard or Advanced.
  
• Step 6: Enable the shows deleted and advanced deleted records option.
  
• Step 7: Select the Collation option Auto detect or Manual.
  
• Step 8: Select the Log file path and click Ok to start scanning.
  
• Step 9: A tree structure gets loaded on the software wizard containing MDF files data. Select the folders that you want to save.
  
• Step 10: Here, you can also preview the details of the specific folder.
  
• Step 11: Now, click on the Save button, either choose SQL Server Database or SQL Server Compatible SQL Script.
  

Steps to Restore Recoverable SharePoint MDF file Data into SQL Server Database

• Step 12: The software offers you two different options: Windows Authentication and Server Authentication.
  
• Step 13: First, we go for Windows Authentication. Here, you have to enter the erver Name and Database Name. Or, you can also save it in the existing database.
  
• Step 14: Please enable some other advanced features if required:
  1. Export with schema and data:- It allows users to restore recoverable data, including schema.
  2. Export with only schema:- You also have a feature to restore only schema from the chosen folders.
  3. Save maximum Length of Column:- It helps users download the column's full size if possible.
  4. Export with schema and data:- Use this option to download collation of Columns separately.
  5. Test Database connections:- Click on this button to check the Database connections as if it is working or not.
  
  
• Step 15: You will find a pop-up showing Database Connection established successfully. Click OK Recovery.
  
• Step 16: Finally, the saving process gets completed.
  
• Step 17: Secondly, we go for Server Authentication. Here, you have to enter the following details: User Name, Password, Server Name, and Database name. Or, you can also save it in the existing database.
  
• Step 18: Click on the Test Database Connection to establish the proper connection with the server. Click Ok to start the restoring process.
  
• Step 19: Lastly, the saving process gets completed.
  

Steps to Restore SharePoint Database MDF file Data as SQL Server Compatible SQL Scripts

Follow the steps from 1 to 11, and then go along with the below-described steps to restore SharePoint Database MDF file Data as SQL Server Compatible SQL Scripts:

• Step 12: Opt for the SQL Server Compatible SQL Script option and select the saving location for the output folder. Click OK to start the process.
  
• Step 13: Finally, the SQL script has been completed for the selected database.