O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

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

Planning for Fault Tolerance

SQL Server 2005 solutions typically represent mission-critical systems that are vital to the functioning of an organization. They store data that simply cannot be lost. Consequently, DBAs are typically responsible for designing appropriate fault tolerance for such SQL Server 2005 solutions.

Planning for fault tolerance is all about identifying the various points of failure in your SQL Server 2005 database solution and providing redundancy at these potential points of failure, which include the following:

  • Server hardware
    • Processors
    • Memory
    • Controllers
    • Disk drive storage
    • Power supply unit (PSU)
  • Network
    • Network cards
    • Hubs
    • Switches
    • Routers
    • Cabling
  • Power supply

In certain cases of catastrophic failure, providing ...

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