Anything else indicates a thirdparty
backup.
Flags This bitmap specifies information such as whether a backup has bulklogged
data or whether a backup is damaged. This information is also
given in other, more specifically labeled columns of the report. Don??™t
rely on the bitmap, as the meanings could change in the future.
Instead, focus on the actual columns.
Collation This is the database-level collation, not the server-level collation.
Keep in mind that different collations can exist all the way down to the
column level.
CHAPTER 3 n RESTORING A DATABASE 49
The attributes listed in Table 3-1 aren??™t the only attributes returned by the RESTORE
HEADERONLY command, but the others are either self-explanatory or of marginal use. Much
of the information is repeated within MSDB, which is a good place to look if you??™re collecting
data for trend analysis.
RESTORE FILELISTONLY
When more than one backup is written to the same device, you??™ll need to use the following
command to identify the position of any given backup:
RESTORE FILELISTONLY
FROM DISK = 'D:\SQLBackups\AWFull.
Pages:
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135