Software Guide for SharePoint Server Recovery Tool

Step-1: Install and Run Tool

Start the DatabaseFileRecovery SharePoint Server Repair Tool as an administrator on your system.

step 1
Step-2: Open SharePoint Files

Click Open to view the dialog to browse the MDF file path from your system.

step 2
Step-3: Select Recovery Option

Now, select the Recovery option as per your requirement.

  • Complete Database Recovery: To recover all of your data that is stored within the SharePoint Server.
  • Document Recovery: If you choose this option, the software recovers SharePoint data and shows them in a tree structure to save.
step 3
Step-4: Add MDF File

Now, click the Browse (...) icon to add the SharePoint Server MDF file from the system for recovery.

step 4
Step-5: Choose Recovery Mode

Select the Recovery mode as per the level of corruption, either Standard or Advanced.

step 5
Step-6: Pick Option for Deleted Records

Enable the Shows deleted and Advanced deleted records option to view all the records in the file.

  • Standard Mode: Use this when your SQL backup file is less corrupted.
  • Advanced Mode: Utilize it when your SQL backup file is severely corrupted.
step 6
Step-7: Choose Collation Option

The software also provides you with the Collation option: Auto-detect or Manual. You can pick one as per your needs.

step 7
Step-8: Enter Log Path

Select the Log file path and click Ok to start scanning the added MDF file for recovery.

step 8
Step-9: Expand Tree Format

A tree structure gets loaded on the software wizard containing MDF file data. Click OK and Select the folders that you want to save.

step 9
Step-10: Preview MDF File Data

Here, you can also preview the details of the specific folder by double-clicking it in the preview panel.

step 10
Step-11: Save Recovered Data

Now, click on the Save button, and either choose SQL Server Database or SQL Server Compatible SQL Script.

step 11
Step-12: Save in SQL Database

The software offers you two different options: Windows Authentication and Server Authentication.

step 12
Step-13: Select Windows Authentication

First, we go for Windows Authentication. Here, you have to enter the Server Name and Database Name. Or, you can also save it in the existing database.

step 13
Step-14: Apply Filters

Please enable some other advanced features if required:

  • Export with schema and data: It allows users to restore recoverable data, including schema.
  • Export with only schema: You also have a feature to restore only schema from the chosen folders.
  • Save maximum Length of Column: It helps users download the column's full size if possible.
  • Export with schema and data: Use this option to download the collation of columns separately.
step 14
Step-15: Test Database Connections

Click Test Database Connections to check if it is working or not. You will find a pop-up showing Database Connection established successfully. Click OK.

step 15
Step-16: Alternatively, Choose Server Authentication

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 16
Step-17: Test Connection

Click on the Test Database Connection to establish the proper connection with the server. Click Ok to start the restoring process.

step 17
Step-18: Process Completes

Finally, the saving process is completed and your SharePoint files are stored in the SQL Database. Click OK.

step 18
Step-19: Save As Scripts

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 19
Step-20: Recovered SharePoint Files

Finally, the SQL script has been completed for the selected database and you have saved files successfully. Click OK.

step 20