The metrics in this category provide detailed backup information for all databases.
Default Collection Interval — in real time
Table 1-26 Database Backup Metrics
| Metric | Description |
|---|---|
|
Backup Set ID (key column) |
Unique backup set identification number that identifies the backup set. |
|
Media Set ID (key column) |
Unique media set identification number that identifies the media set containing the backup set. |
|
Family Sequence Number (key column) |
Position of this media family in the media set. |
|
File Number (key column) |
File identification number unique within a database. |
|
Mirror Number (key column) |
Mirror identification number unique within a database. |
|
Backup Set Name |
Name of the backup set. Can be NULL |
|
Backup Set Description |
Description of the backup set. Can be NULL. |
|
Username |
Name of the user performing the backup operation. Can be NULL. |
|
Start Date |
Date and time the backup operation started. Can be NULL. |
|
Finish Date |
Date and time the backup operation finished. Can be NULL. |
|
Size of Backup (bytes) |
Size of the backup set, in bytes. Can be NULL. |
|
Database Name |
Name of the database involved in the backup operation. Can be NULL. |
|
Server Name |
Name of the server running the SQL Server backup operation. Can be NULL. |
|
Machine Name |
Name of the computer running SQL Server. Can be NULL. |
|
Media Set Name |
Name of the media set. Can be NULL. |
|
Media Set Device Name |
Physical name of the backup device. Can be NULL. |
|
Physical Block Size (Bytes) |
Physical block size used to write the media family. Can be NULL. |
|
File Group Name |
Name of the filegroup containing a backed up database file. Can be NULL. |
|
File Group Physical Name |
Remainder of the physical (operating system) file name. Can be NULL. |
|
Backup Set Expiration Date |
Date and time the backup set expires. Can be NULL. |