SEARCH
0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Prev | Current Page 104 | Next

James Luetkehoelter

"Pro SQL Server Disaster Recovery"

The only way to recover from a tornado strike is if you put your
backups on a tape and either take them offsite or place them in a fire-resistant safe
cemented into the foundation of the building.
??? Hardware: Again, location is the key to mitigating hardware failure. Whether it??™s
keeping a backup on another server or another tape, location addresses most hardware
failure scenarios.
CHAPTER 2 n MAKING DATABASE BACKUPS 38
??? Media: Location itself doesn??™t mitigate media failure; the key is using multiple
locations.
??? Process: The location for process failures is only relevant in the protection of transaction
log backups.
??? User: Again, location only affects user failure in that it can help protect transaction
log backups.
Backup Methods
This time, this list is centered around how your backup method impacts your recovery
options:
??? Environmental: None of the backup methods mentioned help if a tornado destroys
your facility.
??? Hardware:Mirrored backups are a great way to minimize the risk of hardware failure.
If you mirror your backups to four tape drives, any one can fail without
impacting your recovery capabilities.


Pages:
92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116