SQL Server Backups
The metrics in this category provide a list of backups that can be restored or deleted through the plug-in job process.
Table 2-71 SQL Server Backups Metrics
| Metric | Description |
|---|---|
|
Backup File |
Backup file with full path. |
|
Server Name |
Server name. |
|
Database Name |
Name of database that has been backed up |
|
Backup Finish Date |
Backup finish date |
|
Backup Size (byte) |
File size of backup |
|
Backup Type |
Type of back up.
|
|
Media Set Id |
Media set ID |
|
File Position |
Position of database backup in backup file. |
|
Backup GUID |
Unique identifier for the backup. |
|
Differential Base GUID |
Unique identifier of the differential base. |
|
Recovery Model |
Recovery model of the database at the time of the backup (SIMPLE, BULK_LOGGED, or FULL). |
|
Database Backup LSN |
Log sequence number of the most recent full database backup at the time this backup was taken. |
|
Checkpoint LSN |
Log sequence number of the checkpoint recorded when the backup was created. |
|
First LSN |
Log sequence number of the first log record in the backup set. |
|
Last LSN |
Log sequence number of the next log record after the backup set. |
|
Backup Start Date |
Date and time at which the backup operation started. |