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.

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial