Recover SharePoint - Revision history

Sachin at 16:24, 9 December 2019

2019-12-09T16:24:57Z

Sachin: /* Step 8 */

2019-12-09T16:15:21Z

‎Step 8

Sachin: /* Step 7 */

2019-12-09T16:14:39Z

‎Step 7

Sachin: /* Step 5 */

2019-12-09T16:10:52Z

‎Step 5

Sachin: /* Step 5 */

2019-12-09T16:09:16Z

‎Step 5

Sachin: /* Step 6 */

2019-12-09T15:20:15Z

‎Step 6

Sachin: /* Step 5 */

2019-12-09T15:20:05Z

‎Step 5

Sachin: /* Step 1 */

2019-12-09T15:17:41Z

‎Step 1

New page

The following method has been tested with the versions of Microsoft SharePoint 2010 for recovering the Database Files and getting the server back up and running.
__NOTOC__
==='''Step 1'''===
Login to the NetBackup GUI and navigate to '''Backup, Archive and Restore''' section.

[[File:NBU-Restore-S1.jpg]]

==='''Step 2'''===
Click on the '''Restore Files''' tab and select the Source, Destination Client and type of Policy to restore the SharePoint backup files.
The '''Policy Type''' will be '''Standard'''.

[[File:SharePoint-RestoreSelection.JPG]]

==='''Step 3'''===
Under '''Browse Directory''' select the DB files files to restore.

[[File:SharePoint-BrowseDirectory.jpg]]

==='''Step 4'''===
Chose to restore to a different location, and change the target destination to a temporary location on any Unix machine. Then restore the files and copy the restored files to the SharePoint server.

[[File:SharePoint-RestoreDirectory.jpg]]
[[File:SharePoint-Copy-Restored-Files.jpg]]

==='''Step 5'''===
Initiate the restore process from NetBackup. Example of a temporary location can be '''"C:\Temp\DB_Name.bak"'''.

==='''Step 6'''===
Log in to MS SQL Management Studio, right click on Databases and choose '''Restore Database'''.

[[File:MSSQL_Restore_DB_01.jpg]]

==='''Step 7'''===

Select desired database from the drop down menu as the destination. For the source select '''From Device''' and use the '''BAK''' file on the temporary location. Make sure to select the '''Restore''' checkbox as in the picture below.

[[File:MSSQL_Restore_DB_02.jpg]]

==='''Step 8'''===

Select '''OK''' and this will restore the contents from the BAK file to the desired Database.

----
Use this link to go back to the main [[recoverydocs]] Page.

← Older revision		Revision as of 16:15, 9 December 2019
Line 38:		Line 38:

	[[File:SharePoint_SQLCMD_Restore_DB.jpg]]		[[File:SharePoint_SQLCMD_Restore_DB.jpg]]
−
−	~~==='''Step 8'''===~~
−
−	~~Select '''OK''' and this will restore the contents from the BAK file to the desired Database.~~
−
−	~~----~~
−	~~Use this link to go back to the main [[recoverydocs]] Page.~~

@@ Line 25: / Line 25: @@
 ==='''Step 5'''===
-If your SharePoint farm has SQL Server Management Studio installed then please follow this step , else jump to step 10.
+If your SharePoint farm has SQL Server Management Studio installed then please follow this step , else jump to step 6 to restore using SQLCMD.
 Login to the SSMS and do a native MSSQL Database restore from .BAK files.

@@ Line 1: / Line 1: @@
-The following method has been tested with the versions of Microsoft SharePoint 2010 for recovering the Database Files and getting the server back up and running.
+The following method has been tested with the version of Microsoft SharePoint 2010 for recovering the Database Files and getting the server back up and running.
 __NOTOC__
 ==='''Step 1'''===

@@ Line 33: / Line 33: @@
 [[File:SharePoint_SSMS_Restore_DB-2.jpg]]
-==='''Step 7'''===
+==='''Step 6'''===
-Select desired database from the drop down menu as the destination. For the source select '''From Device''' and use the '''BAK''' file on the temporary location. Make sure to select the '''Restore''' checkbox as in the picture below.
+Use SQLCMD to restore your DB as shown in the below screenshots.
-[[File:MSSQL_Restore_DB_02.jpg]]
+[[File:SharePoint_SQLCMD_Restore_DB.jpg]]
 ==='''Step 8'''===

@@ Line 23: / Line 23: @@
 [[File:SharePoint-Copy-Restored-Files.jpg]]
-==='''Step 6'''===
+==='''Step 5'''===
 Log in to MS SQL Management Studio, right click on Databases and choose '''Restore Database'''.