If you configure the striped backup properly,
the speed of the restore should be significantly faster than a single-file restore. The catch
is that all of the files in the backup stripe must exist:
RESTORE DATABASE AdventureWorks
FROM DISK='D:\SQLBackups\AWFull.bak',E:\SQLBackups\AWFull.bak
WITH NORECOVERY
If either of those files is missing, the entire backup will be lost. Use striped backups
with caution. If you recall from the previous chapter, it can be easy to accidentally create
a striped backup.
If you need to stripe a backup across multiple tape drives, it may be better to let the
hardware itself handle that via a tape array or an autoloader. With large databases, you
usually don??™t have a choice, and leaving the striping work to just the hardware may be a
better choice. I??™ll discuss hardware-related subjects in Chapter 10.
Verifying Backups
SQL Server has always provided a means to verify backups, either with BACKUP
VERIFYONLY or RESTORE VERIFYONLY.With versions 2000 and earlier, running these commands
only did a basic scan of the structural integrity of the file.
Pages:
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154