When
you??™re performing a restore with the GUI, some of the information displayed is a combination
of both the information contained in the backup header and the information
within MSDB (which I??™ll cover shortly).
You can normally issue the RESTORE HEADERONLY command simply by referencing the
backup file:
RESTORE HEADERONLY
FROM DISK='D:\SQLBackups\AWFull.bak'
If you??™re referencing a tape device, you may also specify the options of
UNLOAD|NOUNLOAD and REWIND|NOREWIND. These options go in the RESTORE command??™s
optional WITH clause and don??™t apply to disk-based backup files.
CHAPTER 3 n RESTORING A DATABASE 47
Also, keep in mind that RESTORE HEADERONLY returns all backups contained on the
device referenced, whether it??™s simply a file that contains more than one individual
backup, a logical backup device, or a tape volume. To view an individual backup set or
file, use WITH FILE or WITH MEDIANAME (for tapes) to filter the result set.
Rather than discuss every property returned by this command (there are more than
30), I??™ll focus on the ones that are either very useful or potentially misleading.
Pages:
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130