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.
- Select File > Restore SQL Server objects.
- In the Backup History Options dialog box, in the SQL Host list, select the host that has the database you want to restore.
- Indicate the Source Client, if applicable.
In most cases when you browse for backup images, you only need to specify the SQL Host name. When the NetBackup client name and the host name are different you also need to also provide the Source Client name. For example, if the NetBackup client name is the network interface name. For Intelligent Policies, you also need to indicate the Source Client if you add or register the instance with a host name that is different than the NetBackup client name.
- Click OK.
- 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.