NetBackup™ for Microsoft SQL Server Administrator's Guide

To configure NetBackup to support database mirroring

1. The hosts that contain both databases should specify the same primary server in their server lists.
2. Any policy that is used to back up the principal should also specify the host that contains the mirror database.

   See Performing simultaneous backups for mirrored partners.

3. On the primary server, configure permissions for a redirected restored for both mirroring partners.

   See Configuring permissions for redirected restores.

4. (Conditional) If you specify the fully-qualified domain name (FQDN) for the client in the backup policy, you need to create an alias for the short client name. This alias lets you successfully browse for a backup image and restore it in a mirrored environment. NetBackup attempts to find a mirrored partner backup image using the short name of the client host (for example, client1). However, the backup image in this case is stored using the FQDN (for example, client1.domain.com).

   You can create an alias in one of the following ways:

   • On the NetBackup client, create the following touch file:

     install_path\dbext\mssql\ClientNameMapping.txt

     Add an entry <short name of client host> <FQDN of client host>. For example:

     client1 client1.domain.com

   • On the NetBackup primary server, use the bpclient command to create the alias:

     bpclient -client client_name -M master_server -add_alias alias_name

     For example:

     bpclient -client client1.domain.com -M primary.domain.com -add_alias hpe013-vm02

     You must use the FQDN for the -client argument.