Difference between revisions of "Recovery as Normal Files(MS-SharePoint)"

From Tranzman Documentation
Jump to: navigation, search
 
(One intermediate revision 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. ( 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).  
+
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).  
  
  

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.png 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


SharePoint1.JPG


Step 1

Login to SSMS(SQL Server Management Studio) and connect to the SQL Server Instance.


SQL SharePoint Connect.JPG


Step 2

Right Click and select Restore Database.


SQL Restore Database.JPG


Step 3

From Device , select the data file to restore.


SQL Select DataFile.JPG



Step 4

Click on OK and start the restore. Your data should start restoring.


SQL Restore Progress.JPG


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


SQL Data Restored.JPG


Return to VERITAS NetBackup Recovery