The Operation Status area displays a list of all backup, restore, and virtual database operations performed for the selected object for the last 7 days. To change how much status information you see, click Filter and then select a different date Range in the Event Time settings.

You can re-run any previous backup operation from this grid. 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.

What column information can you select?

ColumnDefinition
Progress

During an operation, the progress bar will denote the percentage of the operation completed.

  • When the operation is complete, it will display a green bar labeled 100%.
  • If an operation is completed with errors, this column will display a red bar labeled Error.
  • If an operation is completed with warnings, this column will display a yellow bar labeled 100% with an asterisk. This column also indicates when the backup file has been deleted (groomed) and therefore is no longer available to be restored.
  • Operations performed to offline databases are skipped and shown as it.
InstanceDisplays the name of the SQL Server instance that was backed up, restored, or its database was mounted by this operation.
DatabaseDisplays the name of the database that was backed up, restored, or mounted by this operation.
OperationDisplays the type of operation performed. The types are Backup, Restore, Verify, and Virtual Database.
Backup TypeDisplays the type of backup performed by the operation. The types are Full, Log, Differential, and File.
CompressedDisplays the size of the backup file after compression.
RatioDisplays the ratio of the Uncompressed size of the database reported by SQL Server to the resulting Compressed size of the backup file created by SQL Safe.
CompressionDisplays the type of compression used for the backup.
Database SizeDisplays the size of the original database.
UncompressedDisplays the size of data contained in the database, as reported by SQL Server.
EncryptionDisplays the type of encryption SQL Safe used during the backup operation.
DurationDisplays the time ( hours:minutes:seconds ) required to complete the operation.
Start TimeDisplays the start date and time of the operation.
End TimeDisplays the end date and time of the operation.
ThreadsDisplays the number of threads SQL Safe used during the backup operation.
FormatDisplays the backup format. SQL Safe backup (Safe) or native backup (Bak) format.

How do you customize the columns in the grid?

Task

Action

Add or remove columns in the grid

Click Filter in the pane title bar, then select the columns you want to display in the grid.

Sort the content of a column

Click on the column header to sort the column in ascending order; click again to sort the column in descending order.

Rearrange the order of the columns

Click on the column header and drag it to a new position in the grid.

Group column headings

Click on the column header and drag it to a position beneath the column header by which it will be grouped.

How do you refresh the operations status?

If a recent operation does not appear in the status view, you can refresh the status of this pane by clicking the Refresh icon in the pane title bar.

Why is the Backup/Restore/Virtual Database Operation Status grid blank?

SQL Safe only displays operation status information for Backup Agents running with an enterprise edition license. If the Backup Agent has a SQL Safe Lite or SQL Safe Freeware Edition license, this pane will be blank.

You may view the operation status for SQL Safe Lite or SQL Safe Freeware Edition Backup Agents by installing a purchased license. To use a trial before purchase, click Enable Trial License. For more information, see manage license.



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels