This is where SQL Server really shines, in my opinion. Forget the performance
improvements, CLR integration, native web services??”all the sexy features. The product
pays for itself by providing intuitive methods for creating multiple mitigation plans that
reinforce each other.
Complementary Technologies
SQL Server 2005 should truly change the way we think about disaster recovery plans.
New technologies provide for creative approaches to mitigation and can be combined in
interesting ways to protect against multiple disaster categories. The traditional method
of disaster mitigation involved either failover clustering or having some sort of remote
standby database used either log shipping or replication. (For the record, I don??™t endorse
replication to create a standby database.)
We need to move away from the belief that a single technique will suffice. If we have
the opportunity to put more than one mitigation process in place, why not use all our
options? After all, we expect hardware installations to have redundant systems, such as
multiple power supplies and RAID protection for disk arrays.
Pages:
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505