O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide by David W. Tschanz, J. Steven Jones

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 10

Designing a SQL Server 2005 Solution for High Availability

MICROSOFT EXAM OBJECTIVES COVERED IN THIS CHAPTER:

  • Develop a strategy for migration to a highly available environment.
    • Analyze the current environment.
    • Ascertain migration options.
    • Choose a migration option.
  • Design a highly available database storage solution.
    • Design the RAID solutions for your environment.
    • Design a SAN solution.
  • Design a database-clustering solution.
    • Design a Microsoft Cluster Service (MSCS) implementation.
    • Design the cluster configuration of the SQL Server service.
  • Design database mirroring.
    • Design server roles for database mirroring.
    • Design the initialization of database mirroring.
    • Design a test strategy for planned and unplanned role changes.

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