Viewing the SQL Server instances and instance groups in instance management
In the NetBackup Administration Console, expand the Applications > Microsoft SQL Server node. Under that node are the following subnodes:
All Instances
This node includes a complete list of all SQL Server instances that NetBackup discovers or that you manually added.
To immediately discover any new instances that you added to your environment since the last discovery ran, choose .
Instance Groups
This node displays an instance groups that you created. You can use instance groups to organize instances and to register all instances in the group with a single set of credentials.
Table: Properties in Instance Management describes the properties for instances and instance groups.
Table: Properties in Instance Management
Column | Description |
|---|---|
Cluster Type | Cluster Type |
Edition | The SQL Server edition. |
Host | The name of the host on which the instance resides. This host name is the name used for the backup in the NetBackup catalog. For a host that uses a multi-interface network connection (multi-NIC), NetBackup discovers and adds the host with the NetBackup Client name. If you installed the NetBackup client with the public interface name, you must also add and register the instance with its private interface name. Then add the instance with the private interface name to the backup policy. For a SQL Server cluster, the host name is the virtual name of the SQL Server cluster. If you have SQL Server cluster with a multi-NIC, you must also add and register the instance with the private name of the virtual SQL Server. |
Instance Group | The instance group name that this instance is part of. This field is blank if the instance does not belong to an instance group. |
Instance Name | The instance name. For a SQL Server cluster, NetBackup adds a single entry or one instance to instance management. The host name for that instance is the virtual name of the SQL Server cluster. |
OS | The operating system of the host. |
Policies | The name of any Intelligent Policies in which the instance or the instance groups appear. Legacy policies (using clients and batch files) are not reflected here. |
Registered | Reflects the date and time when the instance was registered with valid credentials. This field is blank if the instance is not registered. |
Release | The SQL Server release name. |
SP | The SQL Server service pack number. |
State | Active - The instance is available for backup by NetBackup. Inactive - This instance is inactive and cannot be backed up. This state implies that a NetBackup administrator purposely marked the instance as inactive in NetBackup. For example, if the instance is under maintenance. |
Version | The SQL Server version number. |
Since the discovery process does not run continually, any SQL Server instances that you add to your environment are not immediately discovered and added to the NetBackup database. The following procedure describes how to start NetBackup Discovery to find new instances.
To discover the SQL Server instances that you added after the last discovery
- Open Applications > Microsoft SQL Server > Instances.
- From the Actions menu select Discover Instances.