Difference between revisions of "Recovery as Normal Files(MS-SharePoint)"
Line 43: | Line 43: | ||
From Device , select the data file to restore. | From Device , select the data file to restore. | ||
+ | |||
[[File:SQL_Select_DataFile.JPG | border|900x600px]] | [[File:SQL_Select_DataFile.JPG | border|900x600px]] | ||
+ | |||
Revision as of 11:13, 14 July 2021
Below documentation shows how to restore SharePoint data after it has been recovered as normal files using steps as shown in Recovery as Normal Files. Please recover the SharePoint database files as shown below. Once you have the files, please follow the steps to restore.
Since SharePoint sits on top of SQL Server, which is a relational database management system so eventually we will be doing SQL database restores.
For more information about database types and descriptions please read https://docs.microsoft.com/en-us/sharepoint/technical-reference/database-types-and-descriptions.
Below we have demonstrated the restore steps along with the example. ( As the steps are similar to normal SQL database restores so it's up to users preference whether they prefer SQL Server Management Studio, SQL Query or the command line).
Note: Please note currently work has been done for the SharePoint farm content data restore. Work is still in progress for SharePoint Farm configuration restore. |
We are demonstrating restore of database named SharePoint_AdminContent_3cad2f2b-76a6-4621-93bf-cd2668d18eb4.
Step 1
Login to SSMS(SQL Server Management Studio) and connect to the SQL Server Instance.
Step 2
Right Click and select Restore Database.
Step 3
From Device , select the data file to restore.
After that , optionally you can click on Verify Backup Media too.
Step 4
Click on OK and start the restore. Your data should start restoring.
Step 5
Verify the restored data,once restore has been successful