On the Managed Instances section of the Home tab you can see a summary view of all your registered SQL Server instances on your environment. For each instance, SQL Safe Backup displays the following information:
- Status - you can see an up status when the Instance is connected and the SQL Safe Backup Agent is running. You get a down status when either the Instance connection failed or the SQL Safe Backup Agent is not running.
- Instance Name - the name of your SQL Server instance.
- SQL Server version - the version of your SQL Server instance.
- Status text - in this column you can view the detailed description of your Status. For example, if it shows a down status, SQL Safe Backup displays whether is due to an Instance connection failure, the SQL Safe Backup Agent could not be contacted, or some other error occurred.
- # of Databases - displays the number of databases per SQL Sever instance. Click this number and SQL Safe Backup displays the Databases tab filtered by the selected instance.
- # of Policies - displays the number of policies that include at least one database of the respective SQL Sever instance. Click this option and SQL Safe Backup takes you to the Policies tab where you can see the list of all the policies related to your SQL Server instance.
- # of Operations with failure - displays the number of operations for this instance where the last status is a failure. Click this option and SQL Safe Backup takes you to the Operation History tab where you can see all those operations with an Error status and filtered by your selected instance.
What other actions can you perform on the Managed Instances section?
- Add instance - click this option to register new instances. Go to Adding SQL Server instances to find more information about registering new instances.
- Create policy - click this option to access the Backup, Restore, and Log Shipping Policy wizards.
- Backup - this option opens the Backup Wizard. Go to Using the Backup Wizard to know more about the steps for setting up backup operations.
- Restore - this option lets you choose among restoring: Database(s) or Object Level Recovery. Select the respective option and SQL Safe Backup opens the Restore Wizard.
- Export - you can export the information available about your SQL Server instances in any of the following formats: PDF, XLS, or XML.
Additional options - Click the gear icon
to access this wiki or check for updates.Take into account that none of these options are available for Read-only users.