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 ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): 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