MirrorCount For the specific backup set family, the number of mirrored backups that
were created.
You won??™t find yourself using this command often, unless you use SQL Server to back
up directly to tape. In most environments where that is the case, you??™d use a third-party
tool that provides its own method for examining the contents of the tape.
RESTORE VERIFYONLY
This verify-only option lets you interrogate and validate any particular backup file (and
verify does mean what it implies??”the restore operation doesn??™t actually restore any
data). The RESTORE VERIFYONLY command is functionally equivalent to BACKUP VERIFYONLY.
You simply specify the file to check:
RESTORE VERIFYONLY
FROM DISK = 'D:\SQLBackups\AWFull.bak'
There are significant improvements to the verification process. Initially, this command
only verified the logical structure of the backup file; now it goes so far as to validate
the structure of individual objects contained in the backup file. If various page-validation
options, such as torn-page detection or checksum validation, are specified in the backup
file, the RESTORE VERIFYONLY operation will go through and validate the actual data as well.
Pages:
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138