You don??™t need to worry about T-SQL syntax
errors, and the cataloging features of third-party software simplify locating and initiating a restore. If your
environment doesn??™t have these requirements, the agent software is probably an unneeded expense.
Comparison of Backup Locations
As you??™ve seen, there are a variety of options when it comes to backup locations. So how
do they stack up? Table 2-1 breaks it down, comparing backup speed, backup reliability,
and storage reliability.
CHAPTER 2 n MAKING DATABASE BACKUPS 24
Table 2-1. Comparison of Backup Locations
Location Type Speed Backup Reliability Storage Reliability
Local disk Typically the fastest Since it runs quickly, it??™s less Storing backups locally is a risk
likely to have errors occur to disaster recovery. Environduring
the backup process. mental, hardware, and media
disasters compromise not only
your active system, but also your
means of restoring it.
Tape Typically the slowest Tape is generally a more Although delicate, you may store
delicate medium than a tapes off-site in a secure locahard
disk, plus the process tion.
Pages:
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91