Clients sometimes request the use of network drives, but usually because
either they don??™t know where a UNC location is or because the UNC location changes
periodically.
Combining multiple locations is usually the best method. I usually recommend creating
a backup file locally, then either backing it up to tape or copying it to a network
location. Combining techniques will be a recurrent theme throughout this book; focusing
on a single option is often what creates problems in overall planning.
Logical Backup Devices
You can create logical backup device names, usually referred to as just backup devices.
They provide an alternative to specifying a file or tape location explicitly in a BACKUP
command. People who use the default backup directory structure created by SQL Server
(Drive Letter:\Program Files\Microsoft SQL Server\??¦) obviously don??™t take advantage of
backup devices. One of the primary advantages to using backup devices is that you can
change the definition of a backup device, and thus of your backup location, without having
to find and change all the commands in your backup and restore scripts.
Pages:
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93