CHAPTER 3 n RESTORING A DATABASE 48
Table 3-1. Information Revealed by RESTORE HEADERONLY
Field Label Information Returned
BackupType Multiple, numeric codes are listed here, some of which correspond to a
SQL Server native backup, some to a third-party backup type. The SQL
Server types are: 1) Database, 2) Transaction Log, 4) File, 5) Full
Differential, 6) File Differential, 7) Partial, and 8) Partial Differential.
For non-SQL Server backup types, there is 1) Normal, 5) Differential,
16) Incremental, and 17) Daily. If you have a non-SQL Server type, be
sure that Differential and Incremental mean what you think they
mean, as discussed in Chapter 2.
ExpirationDate If a datetime is present, it shows when the backup file (not the backup
set, which includes all backup files) will expire. If the backup file is on
a tape device, expiration means that you can overwrite the backup. If
the backup file is on a file-based device, SQL Server will delete that file
after the expiration date.
Compression Currently, SQL Server doesn??™t support compression; there should be a
0 here. If there??™s anything other than a 0, it??™s a third-party backup tool.
Pages:
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133