Difference between revisions of "Recovery as Normal Files(MS-SharePoint)"
| (20 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | 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|Recovery as Normal Files]]. Please recover the SharePoint database files as shown below. Once you have the files, please follow the steps to restore. | + | 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(FileSystem)|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. | Since SharePoint sits on top of SQL Server, which is a relational database management system so eventually we will be doing SQL database restores. | ||
| Line 5: | Line 5: | ||
For more information about database types and descriptions please read https://docs.microsoft.com/en-us/sharepoint/technical-reference/database-types-and-descriptions. | 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. | + | 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). |
| + | |||
{|style="padding: 5px; width: 85%;" | {|style="padding: 5px; width: 85%;" | ||
| Line 13: | Line 14: | ||
__NOTOC__ | __NOTOC__ | ||
| + | |||
| + | We are demonstrating restore of database named '''SharePoint_AdminContent_3cad2f2b-76a6-4621-93bf-cd2668d18eb4''' | ||
| + | |||
| + | |||
| + | |||
| + | [[File:SharePoint1.JPG | border|900x600px]] | ||
| + | |||
===Step 1=== | ===Step 1=== | ||
| + | |||
| + | Login to SSMS(SQL Server Management Studio) and connect to the SQL Server Instance. | ||
| + | |||
| + | |||
| + | [[File:SQL_SharePoint_Connect.JPG | border|900x600px]] | ||
| + | |||
===Step 2=== | ===Step 2=== | ||
| + | |||
| + | Right Click and select Restore Database. | ||
| + | |||
| + | |||
| + | [[File:SQL_Restore_Database.JPG | border|900x600px]] | ||
| + | |||
===Step 3=== | ===Step 3=== | ||
| + | |||
| + | From Device , select the data file to restore. | ||
| + | |||
| + | |||
| + | [[File:SQL_Select_DataFile.JPG | border|900x600px]] | ||
| + | |||
| + | |||
===Step 4=== | ===Step 4=== | ||
| + | |||
| + | Click on OK and start the restore. Your data should start restoring. | ||
| + | |||
| + | |||
| + | [[File:SQL_Restore_Progress.JPG | border|900x700px]] | ||
| + | |||
| + | |||
| + | You might have to take the database offline in case there are any existing connections. | ||
| + | |||
| + | ===Step 5=== | ||
| + | |||
| + | Verify the restored data,once restore has been successful | ||
| + | |||
| + | |||
| + | [[File:SQL_Data_Restored.JPG | border|900x700px]] | ||
| + | |||
| + | |||
| + | |||
| + | [[ VERITAS NetBackup Recovery | Return to VERITAS NetBackup Recovery ]] | ||
Latest revision as of 12:23, 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.
Step 4
Click on OK and start the restore. Your data should start restoring.
You might have to take the database offline in case there are any existing connections.
Step 5
Verify the restored data,once restore has been successful
