Optimizing for immediate failover may not be the best for
the application involved. Will all the data be protected? Will the users notice a performance
impact while mirroring is enabled?
??? Understand your failover and failback scenarios: Even though failover and failback
in database mirroring are significantly less painful than in log shipping, some situations
may require you to break the mirror and re-create it.
CHAPTER 8 n DATABASE MIRRORING 226
Summary
Is database mirroring too good to be true? I don??™t believe so. When it comes to mitigating
disaster situations, there really isn??™t a better solution. Not only can it provide a high level
of disaster mitigation, but it can also ensure transactional consistency. Some of my colleagues
recommend replication as a superior means of disaster mitigation, but I see
replication fitting a different business role??”one of secondary usage in disaster recovery.
I??™m placing my money on database mirroring as the best solution for mitigating database
disasters. In the next chapter, I??™ll talk about database snapshots??”how to create them,
restore them, and manage them.
Pages:
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423