Position A simple integer identifies which backup this is in a backup device
(tape- or file-based).
DeviceType This is a list of both physical and logical type codes, including filebased
backups (2 for logical, 102 for physical), tape (5 for logical, 105
for physical), and virtual devices (7 for logical, 107 for physical). A
virtual device usually indicates a third-party backup utility.
FirstLSN, LastLSN, These fields are entries for the corresponding LSN numbers; consider
CheckpointLSN, these fields for internal use only.
DatabaseBackupLSN
SortOrder, Codepage, These fields represent the configuration at the server level. Keep in
UnicodeLocaleID, mind that you can create different collations at the database and
UnicodeComparisonStyle column level.
BackupStartDate, These fields indicate the times that it starts and finishes writing to
BackupFinishDate media, not necessarily the entire time needed by SQL Server for the
backup. They aren??™t without value, but there is more time involved.
MSDB is a better place to look for execution times.
SoftwareVendorID 4608 references a SQL Server backup.
Pages:
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134