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.

6 thoughts on “How to restore Microsoft SQL databases using NetBackup?

  1. Joe Sica

    How would it differ if you needed to restore the database to a new server? Would using the UNC path of the new server be sufficient?

    Reply
    1. Mariusz Post author

      Hi,

      no UNC. You need to give a permission/access to the new server (e.g. create the No Restrictions file). Then you need to open NetBackup MS SQL Client on the new server and specify old SQL server as a source.

      Reply
  2. Vedamurthy

    Can we create multiple schedules with different retention values for same sql backup with same bch file. in my new environment these kind of policies have been created. and few backups happening properly, wher few are not proper with retention

    Reply
    1. Mariusz Post author

      Do you mean that you created one Automatic and few Application Schedulers?

      Reply
  3. vijay

    hello,

    My question is when i start restore with overwrite option will it first delete the existing db and then restore or after successful restore will it delete the existing db?

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.