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. |