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. |
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.
How can you manage your SQL Servers?
To manage your SQL Server instances, click Servers in the navigation pane, and then click the appropriate node in the Servers tree.
What information is available for your SQL Servers?
On the Instance view, you can find the following information:
- The Instance Information.
- Your Operation Status summary.
- A list of your Backup/Restore Operation Status.
- Your SQL Server status details.