Page History
The The Operations History tab tab allows you to see all operations performed by SQL Safe in your environment. For each operation, you can see the following details:
- Status - this column lets you view the status of each respective operation. Status can be In Progress (percentage and bar indicating the progress of the operation), Queued, Successful, Successful with warnings, Error, Canceled, Skipped, or Deleted.
- Details - the details about the status of the respective operation.
- Instance - the name of the SQL Server instance where the operation was executed.
- Database - the name of the Database where SQL Safe executed the operation.
- Operation - the type of operation (Backup, Restore, Verify, InstantRestore, Hydrate).
- Backup Type - if it is a backup operation, then the type of configured backup.
- Policy - if the operation belongs to a policy, then the name of the policy.
- Compressed, MB MB - the size to which the data was compressed in MB.
- Uncompressed, MB MB - the uncompressed data in MB.
- Ratio, % % - the ratio between compressed and uncompressed data in percentage.
- Database size, MB MB - the size in MB of the database where the operation was performed.
- Compression Compression - the type of compression used for the backup operation.
- Encryption - the type of encryption selected for the backup operation.
- Duration - the total duration of the operation.
- Start time - the exact time when the operation started.
- End time - the exact time when the operation finished.
- Threads - number of threads used by the operation.
- Actions Actions - the gear icon under this column allows you to access options such as Set progress to, Backup again, or Backup with different options. .
Note |
---|
Offline databases are shown as 'Skipped' in the Status column of the operation history panel. |
Tip |
---|
Keep in mind:
|
How can you filter the information on the Operation History tab?
SQL Safe allows you to filter the information on the the Operations History tab so that you can see tab to quickly access your required information.
To filter your SQL Safe operations, go to the left section of the tab where you can find the following options for filtering:
- Status - specify the status of those operations you want to view. An operation can have any of the following status: In progress, Queued, Successful, Successful with warnings, Error, Canceled, Skipped, or Deleted.
- Instance Instance - type those instances for which you want to view their SQL Safe operations.
- Database Database - specify those databases for which you want to view their operations.
- Operation Operation - select those operation types (Backup, Restore, Verify, InstantRestore, Hydrate, or Object Level Restore) you want to view on the the Operation History tab tab.
- Backup Type Type - enter the backup type for which you want to view its operations. You can choose from Full, Differential, Log, or File backup operations.
- Policy Policy - specify if you want to include or exclude policy operations.
Tip |
---|
When using filters take into account:
|
When using filters take into account:
|
What actions can you perform on operations?
Under the the Actions column column, you can find the following options when you click the gear icon:
- Set progress to - use this option to change the status of the operation. You can set it to Successful, Successful with warnings, Error, Canceled, Skipped, or Deleted.
- Backup
...
- Again - use this option if you want to repeat the backup operation. SQL Safe performs the backup with the established backup settings.
- Backup with different
...
- options -
...
- use this option if you want to review or change the backup settings. SQL Safe opens
...
- the Backup
...
- Wizard where you can review the settings used to perform the operation or edit according to your preferences.
- Restore
...
- Again - use this option if you want to repeat the restore operation. SQL Safe performs the restore with the established restore settings.
- Restore with Different
...
- Options -
...
- use this option if you want to review or change the restore settings. SQL Safe opens the Restore Wizard where you can review the settings used to perform the operation or edit according to your preferences.
Warning |
---|
Take into account that these options are not available for Guest role users. |
What other options are available available on the Operations History tab?
The The Operations History tab allows you to perform the following actions located on in the upper section of this view:
- Add
...
- instance - use this option to register new instances. Go
...
...
- to find more information about registering SQL Server instances in your environment.
...
- Export -
...
- use this option to export the information displayed on
...
- your Operations History
...
- tab. Select your preferred format for exporting your information: PDF, XLS, or XML.
Note |
---|
SQL Safe is ONLY compatible with IDERA Dashboard version 4.6 and with limited support. |
Scroll pdf ignore | |||||||
---|---|---|---|---|---|---|---|
IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal |
...