Introduction to NetBackup for SQL Server Technical overview
How does NetBackup resolve SQL Server host and instance names?
Normally SQL Server identifies its installations with a combination that includes the name of the host on which the installation resides plus an instance name. If you omit the instance name then NetBackup assumes that the installation is the default installation on the host. For example, a single host may contain several SQL Server installations, such as, TIGER, TIGER\ACCOUNTING, and TIGER\WAREHOUSE. However, a clustered instance of SQL Server resides jointly on multiple hosts and is identified with a virtual name.
Backups for a host are cataloged under the client name that is specified in the client properties for that host. Ordinarily, the client name is the same as the host name on which SQL Server resides. Normally, this name is the host's NetBIOS name (such as TIGER). However, some backup administrators prefer to identify the client to NetBackup in other ways. For example, an administrator might use the IP name (for example, 18.104.22.168), the fully qualified domain name (tiger.apexworks.com), or an alternate network interface that is attached to the host (tiger1.apexworks.com). For clustered SQL instances, the client name is the virtual SQL Server name that is used for the virtual SQL Server installation.
In most cases when you browse for backup images using the NetBackup MS SQL Client, you only need to specify the SQL Server host name. Specify this name in the Backup History Options dialog box.
(See “Backup options” on page 65 for a description of the available backup options.)
NetBackup then displays the backup images for all of the instances on that host. However, to ensure that NetBackup displays the backup images you want, consider these special cases:
Retrieving backups on a network interface that does not have the same name as the host name (such as tiger1 or tiger.apexworks.com). In this case, the backup images are stored under the network interface name and not the NetBIOS name. To retrieve these images, you should specify the host name in the SQL Host field and the network interface name in the Source Client field.
Retrieving backups from a UNIX (or Linux) server. This scenario may present a problem because UNIX names are case sensitive, whereas Windows names are not. In this case, NetBackup