RecoverMSSQL - Revision history

Admin at 14:22, 16 January 2019

2019-01-16T14:22:43Z

2019-01-16T14:22:17Z

2019-01-16T14:13:04Z

2018-09-18T11:54:38Z

2018-09-18T11:51:10Z

2018-09-18T11:18:04Z

2018-09-18T11:14:31Z

2018-09-18T11:13:56Z

2018-09-18T10:55:25Z

2018-08-30T11:16:39Z

@@ Line 23: / Line 23: @@
 ==='''Step 5'''===
-Initiate the restore process from NetBackup. Example of a temporary location can be '''"C:\Temp\Northwind.bak"'''.
+Initiate the restore process from NetBackup. Example of a temporary location can be '''"C:\Temp\DB_Name.bak"'''.
 ==='''Step 6'''===

@@ Line 23: / Line 23: @@
 ==='''Step 5'''===
-Initiate the restore process from NetBackup. Example of a temporary location can be '''"C:\Temp\New_DB.BAK"'''.
+Initiate the restore process from NetBackup. Example of a temporary location can be '''"C:\Temp\Northwind.bak"'''.
 ==='''Step 6'''===

@@ Line 2: / Line 2: @@
 __NOTOC__
 ==='''Step 1'''===
-Extract all database files to a temporary location on the client SQL Server as a ".BAK" type.
+[[File:NBU-RestoreFiles.jpg]]
 ==='''Step 2'''===
 Log in to MS SQL Management Studio, right click on Databases and choose '''Restore Database'''.
 [[File:MSSQL_Restore_DB_01.jpg]]
-==='''Step 3'''===
+==='''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.
@@ Line 18: / Line 36: @@
 [[File:MSSQL_Restore_DB_02.jpg]]
-==='''Step 4'''===
+==='''Step 8'''===
 Select '''OK''' and this will restore the contents from the BAK file to the desired Database.

@@ Line 14: / Line 14: @@
 ==='''Step 3'''===
-Select desired database form the drop down menu as the destination. For the source select '''From Device''' and point it to the '''BAK''' file on the temporary location.
+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.
 ==='''Step 4'''===

@@ Line 8: / Line 8: @@
 ==='''Step 2'''===
-Open MS SQL Management Studio, log in to the instance and choose '''restore database'''.
+Log in to MS SQL Management Studio, right click on Databases and choose '''Restore Database'''.
 [[File:MSSQL_Restore_DB_01.jpg]]
@@ Line 14: / Line 14: @@
 ==='''Step 3'''===
-For the source select '''From Device''', and point it to the '''BAK''' file of the New_DB.
+Select desired database form the drop down menu as the destination. For the source select '''From Device''' and point it to the '''BAK''' file on the temporary location.
-==='''Step 5'''===
+==='''Step 4'''===
 Select '''OK''' and this will restore the contents from the BAK file to the desired Database.

← Older revision		Revision as of 11:14, 18 September 2018
Line 19:		Line 19:

	Select '''OK''' and this will restore the contents from the BAK file to the desired Database.		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 1: / Line 1: @@
 The following method has been tested with the versions of Microsoft SQL 2008,2012 & 2014 for recovering the Database Files and getting the server back up and running.
-'''Step 1'''
+==='''Step 1'''===
 Extract all database files to a temporary location on the client SQL Server and rename them to a ".BAK" type.
 : '''''i.e. "C:\Temp\New_DB.BAK"'''''
-'''Step 2'''
+==='''Step 2'''===
 Open MS SQL Management Studio, log in to the instance and create a new Blank Database.
@@ Line 12: / Line 12: @@
 [[File:MSSQL_New_DB.jpg]]
-'''Step 3'''
+==='''Step 3'''===
 Right click on the new database, select actions and Restore Database.
@@ Line 18: / Line 18: @@
 [[File:MSSQL_Restore_DB_01.jpg]]
-'''Step 4'''
+==='''Step 4'''===
 For the source select From Device, and point it to the BAK file of the New_DB.
@@ Line 24: / Line 24: @@
 [[File:MSSQL_Restore_DB_02.jpg]]
-'''Step 5'''
+==='''Step 5'''===
 On the left had pane, go to Options, and tell it where the New_DB is located on the SQL Server.
@@ Line 33: / Line 33: @@
 : '''''%system drive%\Program Files\Microsoft SQL\Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\New_DB_log.ldf'''''
-'''Step 6'''
+==='''Step 6'''===
 This would have now restored the backup files from Northwind Database into New_DB.