Browsing for SQL Server backup images

This procedure describes how to browse for a backup image from which you want to restore.

If you have multiple NICs, backups from a UNIX server, a NetBackup client name with a qualified domain name or an IP address, see the following:

To browse for backup images

Change the host and instance you want to access.
Select File > Restore SQL Server objects.
Select the SQL Host whose backup images you want to browse, or type its name.
Indicate the Source Client, if applicable.
- 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.
(Optional) In the Database name filter box, provide a keyword or query to match databases with that name. Filtering on the database name can significantly reduce the time it takes for NetBackup to return the list of backup images.
Select the date range to search and click OK.
Continue with the applicable instructions for how to restore the objects.

How NetBackup resolves SQL Server host and instance names

To ensure that NetBackup displays the backup images you want, consider the following special cases:

If backups are performed on a different network, the images are stored under the network interface name and not the NetBIOS name.
See Performing restores of SQL Server when you have multiple NICs.
Backups from a UNIX server . Since UNIX names are case-sensitive, you must provide the exact client name in the Source Client box field.
SQL Host: TIGER
Source Client: Tiger
The NetBackup client name is a qualified domain name. The SQL Server host name or registered host name (Intelligent Policies) is the NetBIOS name. Specify the SQL Host as the NetBIOS name and the Source Client as the fully qualified domain name.
SQL Host: Tiger
Source Client: tiger.apexworks.com
The NetBackup client name is an IP address. The SQL Server host name or registered host name (Intelligent Policies) is the NetBIOS name. Specify the SQL Host as the NetBIOS name and the Source Client as the IP address:
SQL Host: Tiger
Source Client: 10.80.136.68

More Information