As SQL Server 2005 stands
at this writing, it??™s difficult to establish this level of control. Yes, you can combine clustering
and database mirroring, but would I necessarily recommend it? No. There are too
many variables for my tastes. If you do decide to use this combination, be aware of timing
issues.
Database Mirroring and Log Shipping
I??™ve mentioned the combination of database mirroring and log shipping during lectures,
and the response I see on the faces of my audience is generally one of, ???Did I hear that
CHAPTER 11 n DISASTER RECOVERY PLANNING 275
right? Is he drunk???? Yes, this seems redundant and includes additional configuration with
little to gain from it. It is redundant: that??™s the point. You always consider redundancy
when implementing hardware. Why not expect the same thing from software?
Both database mirroring and log shipping are designed to protect primarily against
environmental disasters. Mirroring provides for fast and simple failover to a remote mirrored
database. Log shipping allows for a remote standby database, but failover is a
complicated process.
Pages:
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508