Skip to Content
MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide
book

MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide

by J. Steven Jones, David W. Tschanz
September 2006
Intermediate to advanced
501 pages
14h 34m
English
Sybex
Content preview from MCITP Administrator: Microsoft® SQL Server™ 2005 Database Server Infrastructure Design Study Guide

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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444)

MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444)

Darril Gibson
Professional SQL Server™ 2005 Administration

Professional SQL Server™ 2005 Administration

Brian Knight, Ketan Patel, Wayne Snyder, Jean-Claude Armand, Ross LoForte, Brad McGehee, Steven Wort, Joe Salvatore, Haidong Ji
Microsoft® SQL Server™ 2005 Administrator's Companion

Microsoft® SQL Server™ 2005 Administrator's Companion

Edward Whalen, Marcilina Garcia, Burzin Patel, Stacia Misner, Victor Isakov

Publisher Resources

ISBN: 9780470047446Purchase book