O'Reilly logo

MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005 by Thomas Moore

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Implementing High Availability

Terms you’ll need to understand:

  • ✓ Database mirroring

  • ✓ Log shipping

  • ✓ Witness

  • ✓ Secondary database

  • ✓ Replication

  • ✓ Publisher

  • ✓ Distributor

  • ✓ Subscriber

  • ✓ Latency

  • ✓ Failover

  • ✓ Clustering

  • ✓ Data mart

  • ✓ Data warehouse

Techniques you’ll need to master:

  • ✓ Utilizing database mirroring with and without a witness

  • ✓ Setting up, initiating, and implementing log shipping

  • ✓ Defining replication and designing the replication architecture

  • ✓ Defining clustering, data mart, and data warehouse

  • ✓ Understanding techniques for controlling latency

High availability is important in most database systems. Having data available 24 hours a day, 7 days a week, every day of the year is important in many environments. Every database administrator aims ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required