Using the Applications utility to view SQL Server objects
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. Instances that belong to an availability group are also included in this list.
Instance Groups
This node displays an instance groups that you created. You can use instance groups to organize instances or replicas and to register all objects in the group with a single set of credentials.
Availability Groups
This node displays all SQL Server availability groups that NetBackup discovers. When you select an availability group, the replicas display in the right pane.
Table: Properties for SQL Server objects in the Applications utility describes the properties for instances, instance groups, and availability groups. Note that some properties are only applicable for certain object types.
Table: Properties for SQL Server objects in the Applications utility
Column | Description |
|---|---|
Availability Group | If an instance that is part of an availability group, indicates the name of the SQL Server availability group. |
Availability Group Name | The name of the availability group. |
Cluster or Cluster Name | The name of the Windows Server Failover Cluster (WSFC). |
Cluster Type | For a clustered instance, indicates the type of cluster. For example, VCS or WSFC (Windows Server Failover Cluster). |
Edition | The SQL Server edition. |
Group ID | The unique identifier (GUID) of the availability group. |
Group Name | The name of the instance group. |
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. For an instance or an availability replica that is hosted on a failover cluster instance (FCI), the host name is the virtual name of the SQL Server cluster. |
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 | 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. |