How to restore Microsoft SQL databases using NetBackup?

By | June 1, 2015

In the previous post here I showed how to use NetBackup to backup/protect Microsoft SQL databases. This post covers restoration of SQL databases. There are two main possibilities:

  1. Restore a database at its original location.
  2. Restore a database to an alternative location.

Restoring database - original location

To restore a database at its original location please follow the below steps:

  1. From the Windows Start menu, select Programs --> Symantec NetBackup --> NetBackup Agents --> NetBackup MS SQL Client.
  2. Select time filter and click OK.How to restore Microsoft SQL databases using NetBackup 2
  3. Select File > Restore SQL Server objects.How to restore Microsoft SQL databases using NetBackup a
  4. In the Restore Microsoft SQL Server Objects dialog box, in the left pane, select the database instance and backup which you want to restore (1). Select Restore selected object (2), Recovery: Recovered (3) and Launch immediately (4) to restore now. Then click Restore (5) to start the process.How to restore Microsoft SQL databases using NetBackup 3
  5. Restore should be done successfully.How to restore Microsoft SQL databases using NetBackup 4

Restoring database - alternate location

To restore a database to alternate location please follow the below steps:

  1. From the Windows Start menu, select Programs --> Symantec NetBackup --> NetBackup Agents --> NetBackup MS SQL Client.
  2. Select time filter and click OK.
  3. Select File --> Restore SQL Server objects.
  4. In the Restore Microsoft SQL Server Objects dialog box, in the left pane, select the database instance and backup which you want to restore. Select Create a move template (1). Save button should be selected (2) and cilck Restore (3).How to restore Microsoft SQL databases using NetBackup alternate
  5. Type a name of restore batch file.How to restore Microsoft SQL databases using NetBackup alternate 2
  6. Remove hash (#) and change a name for database (1), path of database (2) and log (3). Save the file.How to restore Microsoft SQL databases using NetBackup alternate 3
  7. Select File --> Manage script files.How to restore Microsoft SQL databases using NetBackup
  8. Select the restore batch file and click Yes to start the restore process.How to restore Microsoft SQL databases using NetBackup alternate 4
  9. The restore process should be done successfully.How to restore Microsoft SQL databases using NetBackup alternate 5
  10. When you log in to SQL Server using the SQL Management Studio, you should see the restored database.How to restore Microsoft SQL databases using NetBackup alternate 6

NOTES: Above procedures are valid for NetBackup version up to 7.6.x. From NetBackup 7.7, backup/restore of Microsoft SQL has been changed.