The Group, Instance, and Database views display backup and restore details and operation status for all SQL Server instances registered with SQL Safe, as well as at-a-glance summaries of important administrative information. You can view information about a group of SQL Server instances, a single instance, or a database.
| For this node ... | You can view ... |
|---|---|
A server group | Displays the total number of instances in the group, the number of successful and failed operations, and the number of instances up and the number of instances not connected at the time. |
An instance | Displays whether the connection to SQL Server is active, the number of successful and failed operations, whether the SQL Safe Backup Agent is running, the SQL Safe version, the license status, the number of databases on the instance, and the SQL Server version it is running. You can also find the backup and restore operations status for the last 7 days. |
A database | Displays whether the database is currently online, the number of successful and failed operations, and the date of the last backup performed on the database. You can also find the backup and restore operations status for the last 7 days. |
To manage your SQL Server instances, click Servers in the navigation pane, and then click the appropriate node in the Servers tree.
You can re-run any previous backup operation from these views. To re-run a backup, right-click the appropriate operation, and then select Back Up Again (executes backup using previous settings) or Back Up with Different Options (opens the Backup wizard). You can also quickly restore the backup files associated with a specific operation.
What SQL Safe settings are managed in the instance view?
You can install any options you did not include during your initial SQL Safe installation. Click Settings in the Instance Information area, and then select one of the following options, if available:
- Install SQL Safe Backup Agent / Upgrade SQL Safe Backup Agent
- Install SQL Safe Extended Stored Procedures
- Update license
- Enable/Disable SQL Safe InstantRestore
- SQL Safe Agent Properties