Redirecting a SQL Server database to a different host
This topic describes how to redirect a backup to a client that is different from the client that performed the backup. You redirect a restore by performing a database move operation. NetBackup creates a template that you edit to indicate the host and location where you want to redirect the restore. The new location can be a different instance on the same host, a different host, or a different file path. The move operation also lets you restore the database under a different name than the original one. After you edit the template, select to launch it.
Note:
The destination host and instance of a move or restore operation is the one that you log into. For move or restore operations designate the source (or browse) host and the instance when you select .
To redirect a database to another location on a different host
- Establish permissions for redirected restores on the master server.
- The server that backed up the database you want to restore must appear in the server list of the destination host. If the server is not in the list, add it.
- Select File > Set SQL Server connection properties.
- From the Host list, select the host you want to restore to.
- From the Instance list, select the database instance.
To select the default instance, either select <default> or leave the field empty.
- Click Apply and then Close.
- Select File > Set NetBackup client properties.
- In the NetBackup client properties dialog box, from the Current NetBackup Server list, select the NetBackup master server.
This server contains the SQL Server backup images that you want to restore on the destination host. The clients must both use the same master server.
- Click OK.
- Browse for the backup images you want to restore.
For the SQL Host list, select the host that has the database you want to restore.
- In the Restore Microsoft SQL Server Objects dialog box, browse for the database that you want to move.
- From the Scripting list, select Create a move template.
- Click Restore.
NetBackup prompts you to save the template.
- In the Save As dialog box, enter a file name and click Save.
- Click Yes to open the template.
- Edit the template to designate the name that you want to use for the destination database. Also include the file paths that you want to use for each of the database files.