The SQL Server status view allows you to review detailed information regarding Databases and Virtual Databases registered with SQL Safe.
When you select All Databases, you can view information about a group of SQL Server instances, a single instance, or a database. Those views display the backup, restore, and virtual database operation status for all SQL Server instances registered with SQL Safe, as well as at-a-glance summaries of important administrative information.
| For this node ... | You can view ... |
|---|---|
A server group | Displays the total number of instances in the group, the number of instances connected and not connected at the time, and the number of successful and failed operations. |
An instance | Displays the SQL Server Instance status, the SQL Safe version, the license status, the number of databases in the instance, the SQL Server version is running, and the number of successful and failed operations. You can also find the operation status for the last 7 days. |
A database | Displays the database status, the date of the last backup performed on the database, and the number of successful and failed operations. You can also find the operation 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 Backup Again (executes backup using previous settings) or Backup with Different Options (opens the Backup wizard). You can also quickly restore or perform an object level recovery of backup files associated with a specific operation. Or just simply mount a virtual database.
When you select Virtual Databases Only, you can view information about a group of SQL Server instances, or a single instance. Those views display the virtual database operation status for all SQL Server instances whose databases were mounted as a Virtual Database with SQL Safe, as well as at-a-glance summaries of important administrative information.
| For this node ... | You can view ... |
|---|---|
A server group | Displays the total number of instances in the group, the number of instances connected and not connected at the time, and the number of successful and failed operations. |
An instance | Displays the SQL Server Instance status, the SQL Safe version, the license status, the number of databases in the instance, the SQL Server version is running, and the number of successful and failed operations. You can also find the virtual database operation status for the last 7 days.. |
You can mount again any previous virtual database from these views. Right-click the appropriate operation, and then select Mount Virtual Database Again (mounts the virtual database using previous settings) or Mount Virtual Database with Different Options (opens the Virtual Database wizard). You can also quickly perform an object level recovery of 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, then click the appropriate view (All Databases or Virtual Database Only), and select your 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 operation status.
- Your SQL Server status details.