Difference between revisions of "RecoverMSSQL"

From Tranzman Documentation
Jump to: navigation, search
 
(10 intermediate revisions by the same user not shown)
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.
 
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.
 +
__NOTOC__
 +
==='''Step 1'''===
 +
Login to the NetBackup GUI and navigate to '''Backup, Archive and Restore''' section.
  
'''Step 1'''
+
[[File:NBU-RestoreFiles.jpg]]
  
Extract all database files to a temporary location on the client SQL Server and rename them to a ".BAK" type.
+
==='''Step 2'''===
i.e. C:\Temp\New_DB.BAK
+
Click on the '''Restore Files''' tab and select the Source, Destination Client and type of Policy to restore the Exchange backup files.  
 +
The '''Policy Type''' will be '''MS-Windows'''.
  
'''Step 2'''
+
[[File:MSSQL-RestoreSelection.jpg]]
  
Open MS SQL Management Studio, log in to the instance and create a new Blank Database.
+
==='''Step 3'''===
 +
Under '''Browse Directory''' select the SQL instance and database backup files to restore.
  
[[File:MSSQL_New_DB.jpg]]
+
[[File:MSSQL-BrowseDirectory.jpg]]
  
'''Step 3'''
+
==='''Step 4'''===
 +
Chose to restore to a different location, and change the target destination to a temporary location on the SQL Server.
  
Right click on the new database, select actions and Restore Database.
+
[[File:MSSQL-RestoreDirectory.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]]
 
[[File:MSSQL_Restore_DB_01.jpg]]
  
'''Step 4'''
+
==='''Step 7'''===
  
For the source select From Device, and point it to the BAK file of the New_DB.
+
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]]
 
[[File:MSSQL_Restore_DB_02.jpg]]
  
'''Step 5'''
+
==='''Step 8'''===
 
 
On the left had pane, go to Options, and tell it where the New_DB is located on the SQL Server.
 
Sample paths can be as follows;
 
 
 
Program Files\Microsoft SQL\Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\New_DB.mdf
 
 
 
Program Files\Microsoft SQL\Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\New_DB_log.ldf
 
  
'''Step 6'''
+
Select '''OK''' and this will restore the contents from the BAK file to the desired Database.
  
This would have now restored the backup files from Northwind Database into New_DB.
+
----
 +
Use this link to go back to the main [[recoverydocs]] Page.

Latest revision as of 14:22, 16 January 2019

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

Login to the NetBackup GUI and navigate to Backup, Archive and Restore section.

NBU-RestoreFiles.jpg

Step 2

Click on the Restore Files tab and select the Source, Destination Client and type of Policy to restore the Exchange backup files. The Policy Type will be MS-Windows.

MSSQL-RestoreSelection.jpg

Step 3

Under Browse Directory select the SQL instance and database backup files to restore.

MSSQL-BrowseDirectory.jpg

Step 4

Chose to restore to a different location, and change the target destination to a temporary location on the SQL Server.

MSSQL-RestoreDirectory.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.

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.

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.