)
The junior DBA looks at the destination area on the dialog box in Figure 2-8 (the
destination areas in 7.0 and 2000 are similar) and thinks, ???I want to back up to this file
on C:\aw01012008.bak. I??™ve got it highlighted, so that should work.??? He sets the process up
as a recurring job and finds that C:\AW.bak and C:\backup\adventureworks.bak are slowly
growing in size. Since these locations aren??™t where he??™s backing up his data, he deletes
them. Subsequent backups fail.
The backup is striped in between all three files in a round-robin fashion. No single
file has the entire backup; each has a third of the full backup. Since each file would be
required for a restore, the DBA is dead in the water if he encounters a failure.
CHAPTER 2 n MAKING DATABASE BACKUPS 34
Mirrored Backup
Mirrored backups are a new feature in SQL Server 2005 that allow you to write the same
backup file to multiple locations, as Figure 2-9 illustrates. Mirroring is a fantastic technique
to mitigate media failures.
Figure 2-9.Mirrored backup configuration
The command to create a mirrored backup is similar (almost too similar) to creating
a striped backup:
BACKUP DATABASE AdventureWorks TO DISK='D:\data\AW.
Pages:
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109