Redirecting a database to a different location on a different host

The database move redirects the restore of a database to a different location. 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.

Note:

The destination host and instance of a move or restore operation is the one that you log into. The source (or browse) host and instance for move or restore operations is designated by using the Backup History Options dialog box, which comes up automatically when you select File > Restore SQL Server objects.

To redirect a database to another location on a different host

  1. 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.

  2. Select File > Set SQL Server connection properties.

  3. From the Host list, select the host you want to restore to.

  4. From the Instance list, select the database instance.

    To select the default instance, either select <default> or leave the field empty.

  5. Click Apply and then Close.

  6. Select File > Set NetBackup client properties.

  7. In the NetBackup client properties dialog box, from the Current NetBackup Server list, select the NetBackup master server that contains the SQL Server backup images that you want to restore on the destination host.

  8. Click OK.

  9. Select File > Restore SQL Server objects.

  10. In the Backup History Options dialog box, in the SQL Host list, select the host that has the database you want to restore.

  11. Indicate the Source Client, if applicable.

    This option specifies the NetBackup client name for the selected client. This is the name used in the policy to identify the client.

    If you use a specific network interface for backup, enter the network interface name in the Source Client box. The network interface name is defined in the Host Properties for the server (open the properties for the server and click Universal Settings).

  12. Click OK.

  13. Browse for the database that you want to move.

  14. From the Scripting list, select Create a move template.

  15. Click Restore.

  16. In the Save As dialog box, enter a file name and click Save.

  17. Click Yes to open the template.

  18. Edit the template to designate the name that you want to use for the destination database as well as the file paths that you want to use for each of the database files.

  19. After you edit the template, launch it by selecting File > Manage script files.

More Information

SQL Server connection properties

About selecting a server

Redirecting a restore to a different host

About selecting a server