This report depicts the SQL Server backups that have occurred over the specified time period.
Each row contains the following information:
|
Column |
Description |
|---|---|
|
ID |
The backup operation unique numeric identification. |
|
Client |
The name of the client which the backup operation protects. |
|
Instance |
The instance of the SQL Server database being protected. |
|
Database |
The name of the SQL Server database being protected. |
|
Type |
The type of the backup operation. The type may be SQL full, SQL differential, or SQL transaction. |
|
Date |
The date of the backup operation. |
|
Time |
The time of the backup operation. |
|
Last |
Whether the backup operation was the last one of that type for the client being protected. |
|
Additional available columns |
|
|
System |
The name of the system upon which the backup operation resides. |
|
Status |
The status of the backup operation. Green indicates a successful backup, yellow indicates a backup completed with warnings, and red indicates a failed backup. Currently active backup operations are represented with an hourglass. |
|
Complete |
Whether the backup operation has completed or not. |
|
Encrypted |
Whether the backup operation was encrypted or not. |
|
Purgeable |
Whether the backup operation is currently eligible for purging. Purging is the process by which space is made available on the system for additional backups. |
|
Sync/Replication Status |
The vaulting/replication status of the backup operation. |
|
Elapsed |
The elapsed time of the backup operation. |
|
Size (MB) |
The size of the backup operation. |
|
Group |
The group of the SQL Server database being protected. |
|
Order |
The order within the group of the SQL Server database being protected. |
|
Comment |
The comment associated with the backup operation. |
|
Command |
The command associated with the backup operation. This is the actual command that was executed on the client to perform the backup operation. |
|
Output |
The low level detail associated with the backup operation. |
|
SQL Report Summary |
|
|
Total Backups |
The total number of backups found within the specified date range. |
|
Total Size (MB) |
The total size of all available backups in megabytes. |
|
Average Size (MB) |
The average size of all backups in megabytes. |