With mirrored backups, you only need one location from which to
restore.With the previous STOPAT example, you could mix and match copies of the log file
backups. Let??™s say you??™re mirroring your backups between D: (a RAID 5 partition) and
E: (a RAID 1 partition). If one of the backups becomes corrupted, you could simply reference
the other mirror:
RESTORE DATABASE AdventureWorks
FROM DISK='D:\SQLBackups\AWFull.bak'
WITH NORECOVERY -- We aren't done with our Restore process
RESTORE LOG AdventureWorks
FROM DISK='E:\SQLBackups\AWLog1.bak"
WITH NORECOVERY
RESTORE LOG AdventureWorks
FROM DISK='D:\SQLBackups\AWLog2.bak'
WITH RECOVERY, STOPAT 'Jan 10, 2006 3:10pm'
In the previous example, AWLog1.bak ends up being deleted on the D: partition,
whereas the AWLog2.bak file becomes corrupted on the E: partition. There??™s no interdependency
required for restore purposes??”any copy of the appropriate file will do.
CHAPTER 3 n RESTORING A DATABASE 62
Striping Backups
Striped backups require that all pieces of the backup be available at the same time. This
is very different from mirrored backups.
Pages:
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153