Browse SQL Server assets
You can browse instances, databases, and availability groups to view their details such as how they are protected and recovery points that are available.
Note:
Classic policy information is displayed for databases but not for instances or availability groups. The web UI indicates if a protection plan protects the instance, but not if a classic policy does. However, when a backup using a classic policy is performed on an individual database, the Protected by column displays the classic policy name.
On the Instances tab you can view and manage instances, including how they are protected and the instance credentials.
To browse SQL Server instances
- Select the Instances tab.
- To view the available actions for one or more instances, select the check box for the instances. Note that Backup now is only available when you select one instance.
- To view the details for an instance, select the link for the instance. You can perform the following tasks.
To perform an immediate backup of the instance, select Backup now.
Select Add protection to add the instance to a protection plan.
Select Remove protection to remove an instance from a protection plan.
Select the Databases tab to see the databases that are discovered for the instance and their protection information and status.
To view the roles that have access to the instance, select the Permissions tab.
On the Instances tab you can view and manage availability groups, including how database and replica details and how the availability group is protected.
To browse SQL Server availability groups
- To view the available actions for one or more availability groups, select the check box for the availability groups. Note that the Backup now option is only available when you select one availability group.
- Select the link for an availability group to view its details. You can perform the following tasks.
Select Backup now to perform an immediate backup of the availability group.
Select Add protection to add the availability group to a protection plan.
Select Remove protection to remove an availability group from a protection plan.
Select the Databases tab to see the databases that are discovered for the availability group and their protection information and status.
Select the Replicas tab to see the replicas for the availability group, their protection information and status, and any credential that is registered.
Select the Permissions tab to view the roles that have access to the availability group.
Note:
Databases only appear on the tabs if they meet one of the following criteria: A backup exists of the database, the database instance has validated credentials, or a manual discovery of databases was performed.
To browse SQL Server databases
- Select the Databases tab.
- To view the available actions for one or more databases, select the check box for each database. Note that the Backup now option is only available when you select one database.
- Select the link for the database to view its details. You can perform the following tasks.
Review the Database state, which indicates the state of the database in the NetBackup environment:
Active - The database is active in the NetBackup environment and available for backups.
Inactive - This state can indicate that the database is marked as inactive in the NetBackup environment. NetBackup then ignores the database during backups. This state also indicates a database that was deleted from the SQL Server environment. You can recover a database that was deleted from the SQL Server environment. If NetBackup successfully locates the database during discovery or a backup, then it changes the state from Deleted to Active.
Deleted - The database exists in the NetBackup asset database but not in the live SQL Server environment.
Select Backup now to perform an immediate backup of the database.
Select Add protection to add the database to a protection plan.
Select Remove protection to remove a database from a protection plan.
To see the available recovery points for the database, select Recovery points.
To view the restore jobs for the database, select Restore activity.
To view the roles that have access to the database, select the Permissions tab.