Given
that the RESTORE HEADERONLY command displays all the backup sets if multiple backups are
contained within the same file or tape, this command can save you a lot of time in
quickly identifying the particular backup from which you need to retrieve information.
CHAPTER 3 n RESTORING A DATABASE 50
RESTORE LABELONLY
Use the RESTORE LABELONLY command to view the high-level label information for a tape
backup??”for example:
RESTORE LABELONLY
FROM TAPE ='\\TAPE0\\AWFull.bak'
Table 3-3 lists the more significant bits of data returned by the command. The results
are typically most meaningful when dealing with tape backups. It??™s less common to need
to look at high-level labels on backups made to disk.
Table 3-3. Results of RESTORE LABELONLY
Field Label Information Returned
FamilyCount The number of families present on the device. Tape backups are often
divided into families.
FamilySequenceNumber The number identifying the specific family being displayed. You??™ll see a
row of output for each family.
MediaLabelPresent This returns 1 for Microsoft Tape Format (MTF) or 0 for other??”
essentially a third-party format.
Pages:
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137