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:
- Restore a database at its original location.
- Restore a database to an alternative location.
Restoring database - original location
To restore a database at its original location please follow the below steps:
- From the Windows Start menu, select Programs --> Symantec NetBackup --> NetBackup Agents --> NetBackup MS SQL Client.
- Select time filter and click OK.
- Select File > Restore SQL Server objects.
- 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.
- Restore should be done successfully.
Restoring database - alternate location
To restore a database to alternate location please follow the below steps:
- From the Windows Start menu, select Programs --> Symantec NetBackup --> NetBackup Agents --> NetBackup MS SQL Client.
- Select time filter and click OK.
- Select File --> Restore SQL Server objects.
- 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).
- Type a name of restore batch file.
- Remove hash (#) and change a name for database (1), path of database (2) and log (3). Save the file.
- Select File --> Manage script files.
- Select the restore batch file and click Yes to start the restore process.
- The restore process should be done successfully.
- When you log in to SQL Server using the SQL Management Studio, you should see the restored database.
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.
Thank you for good step.
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?
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.
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
Do you mean that you created one Automatic and few Application Schedulers?
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?
Can we run multiple restores at the same time using NBU? What is the easy way to restore all the databases in an instance using SQL NBU?