Page History
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 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 |
instances connected and not connected at the time |
An instance
, 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. |
To manage your SQL Server instances, click Servers in the navigation pane, and then click the appropriate node in the Servers tree.
| Tip |
|---|
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 Backup Again (executes backup using previous settings) or Back Up Backup with Different Options (opens the Backup wizard). You can also quickly restore the 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.. |
| Tip |
|---|
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.
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:
...
| Scroll pdf ignore | |||||||||
|---|---|---|---|---|---|---|---|---|---|
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > > | IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal