Page History
SQL Safe allows you to view a list of all the databases that belong to your SQL Server instances. In this tab you can view the following information for each database:
- Status Status - it displays the status of the database, it can be be OK, Error, or Warning.
- Instance Name Name - the name of the instance where the database resides.
- Database Name Name - the name of the respective database.
- Database Type Type - if it is a User or System database.
- Last Full Backup Backup - the date and time when the last full database backup was executed.
- Last Diff Backup Backup - the date and time when the last differential database backup was executed.
- Last Log Backup Backup - the date and time when the last log database backup was executed.
- # Of Policies Policies - the number of policies that cover the database.
- Space used, MB - the amount of space used by the database in MB.
- Actions - under this column you can find a gear a gear icon with the following options: AdHoc Backup and ,AdHoc Restore, and Create Policy.
Tip |
---|
Keep in mind:
|
What information can you filter in the Databases view?
SQL Safe allows you to filter the information available on the the Databases tab to quickly access your required data. To filter your information, go to the left section of the tab and filter your information according to:
- Status Status - select a database status. You can choose from Ok, Warning, or Error.
- Instance Name Name - type the names of the instances for which you want to see their databases.
- Database Name Name - type the names of the databases you want to view.
- Database Type - select if you want to view view User databases or databases or System databases databases.
- Last Full Backup Backup - use the options the From and and To options to set specific a date range of last Full backups for which you want to view your databases.
- Last Diff Backup Backup - use the options the From and To to options to set specific a date range of last Diff backups for which you want to view your databases.
- Last Log Backup Backup - use the options the From and To to options to set specific a date range of last Log backups for which you want to view your databases.
- # Of Policies Policies - use the options the From and and To so options to set a range of the number of policies for which you want to view your databases.
- Space used, MB MB - use the options the From and and To to options to view the databases that belong to a specific space range in MB.
- Policy Name - type the name of the policies for which you want to view their databases.
Tip |
---|
When using filters take into account:
|
Tip |
When using filters take into account:
|
What actions can you perform on Databases?
On the the Databases tab tab, you can select one or several databases, and click one of the following options from the gear icon under the the Actions column column. You can also use the options from the upper section of this tab.
- Adhoc Backup - select this option to open the the Backup Wizard.
- Adhoc Restore - select this option to open the the Restore Wizard.
- Create Policy - use this option to create a a Backup Policy, Restore Policy, or or Log Shipping Policy. SQL Safe adds the selected databases to the respective policy.
Warning |
---|
These options are not available to Guest users. |
What other options are available on the Databases tab?
You can also find the following options in the upper section of the Databases list:
- Add
...
- instance - use this option to register new instances and launch the Add Instance Wizard.
- Create
...
- policy - select this option to access
...
...
- or Log Shipping
...
- policy wizards.
- Backup - select this option to open
...
- the backup wizard.
- Restore - select this option to open the restore wizard. You can select
...
...
- or perform
...
...
- Export - use this option to export the information displayed on
...
- the Databases
...
- tab, select your preferred format: PDF, XLS, or XML.
Warning |
---|
The Add SQL Server Instanceinstance, Create Policypolicy, Backup, and Restore options are not available to Guest users. |
...