You are previewing SQL Server 2000 High Availability Volume 2: Deployment.
O'Reilly logo
SQL Server 2000 High Availability Volume 2: Deployment

Book Description

The SQL Server High Availability Solution Guide helps database designers and systems engineers implement targeted server redundancy solutions.

Table of Contents

  1. SQL Server 2000 High Availability, Volume 2: Deployment
    1. SPECIAL OFFER: Upgrade this ebook with O’Reilly
    2. Preface
      1. System Requirements
      2. Document Conventions
      3. Acknowledgments
    3. 1. Implementing Failover Clustering
      1. Understanding Failover Clustering
      2. Deploying Failover Clustering
        1. Understanding the Logical Design
        2. Configuring Accounts and Names and Obtaining IP Addresses
        3. Configuring the Network
        4. Configuring Storage Devices
          1. Preparing the Drives
          2. Specifying Drive Letters
        5. Installing and Configuring MSCS
          1. Installing and Configuring MSCS on Additional Nodes in the Cluster
          2. Upgrading the MS DTC
        6. Installing and Configuring SQL Server on the Cluster
          1. Creating a Single Cluster Group
          2. Installing SQL Server
          3. Adding Cluster Disks as SQL Server Dependencies
        7. Applying the Most Recent SQL Server Service Pack
        8. Performing Additional Configuration Tasks
          1. Allocating Memory
          2. Setting New Database Properties
          3. Setting the TCP/IP Port SQL Server Uses
          4. Setting Advanced Failover Options
          5. Configuring Service Properties in a Cluster
      3. Failing Over to a Secondary Node
        1. Testing Failover
        2. Minimizing Failover Time
          1. Understanding Time to Availability
          2. Controlling the Time Required to Detect and Confirm the Fault
          3. Controlling the Time Required to Bring the Resources Online
          4. Controlling the Time Required to Initialize
        3. Reconnecting Clients
      4. Failing Back to the Original Node
      5. Restoring a Node After a Catastrophic Failure
        1. References
    4. 2. Implementing Log Shipping
      1. Understanding Log Shipping
      2. Deploying Automatic Log Shipping
        1. Understanding the Logical Design
        2. Creating and Sharing Synchronization Folders
        3. Creating Database Folders on Each Standby Server
        4. Creating the Log-Shipping Jobs and Initializing the Standby Database
        5. Creating and Executing a Login Synchronization Job
        6. Scripting and Copying Jobs, Alerts, and Operators
        7. Copying DTS Packages
      3. Changing the Role of a Standby Server
    5. 3. Implementing Transactional Replication
      1. Understanding Transactional Replication
      2. Deploying Transactional Replication
        1. Understanding the Logical Design
        2. Creating an Empty Database on Each Subscriber
        3. Creating and Sharing the Snapshot Folder
        4. Creating and Sharing the Synchronization Folder
        5. Preparing the Schema for Replication
        6. Configuring the Distributor
        7. Publishing the Production Database
        8. Configuring and Initializing Subscribers
        9. Creating and Executing a Login Synchronization Job
        10. Scripting and Copying Jobs, Alerts, and Operators
        11. Copying DTS Packages
      3. Changing the Role of a Subscriber
      4. Reverting to the Original Publisher
    6. 4. Implementing Network Load Balancing
      1. Understanding Network Load Balancing
      2. Deploying NLB
        1. Understanding the Logical Design
        2. Obtaining the Public IP Address, Server Name, and Port
        3. Configuring the NLB NIC and Installing and Configuring NLB
        4. Enabling the Primary Server Node
      3. Changing the Primary Server with NLB
    7. 5. Implementing Remote Mirroring and Stretch Clustering
      1. Understanding Remote Mirroring and Stretch Clustering
      2. Deploying a Remote Mirror
      3. Failing Over to a Remote Mirror
      4. Deploying Stretch Clustering
        1. Understanding the Logical Design
        2. Configuring Accounts and Names and Obtaining IP Addresses
        3. Configuring the Network
        4. Configuring Storage Devices
          1. Preparing the Drives
          2. Specifying Drive Letters
        5. Installing and Configuring MSCS
          1. Installing and Configuring MSCS on Additional Nodes in the Cluster
          2. Upgrading the MS DTC
        6. Installing and Configuring SQL Server on the Cluster
          1. Creating a Single Cluster Group
          2. Installing SQL Server
          3. Adding Cluster Disks as SQL Server Dependencies
        7. Applying the Most Recent SQL Server Service Pack
        8. Performing Additional Configuration Tasks
          1. Allocating Memory
          2. Setting New Database Properties
          3. Setting the TCP/IP Port SQL Server Uses
          4. Setting Advanced Failover Options
          5. Configuring Service Properties in a Cluster
      5. Failing Over to a Secondary Node in a Stretch Cluster
        1. Testing Failover
        2. Minimizing Failover Time
          1. Understanding Time to Availability
          2. Controlling the Time Required to Detect and Confirm the Fault
          3. Controlling the Time Required to Bring the Resources Online
          4. Controlling the Time Required to Initialize
        3. Performing a Manual SAN Failover
        4. Reconnecting Clients
      6. Failing Back to the Original Node
      7. Restoring a Node After a Catastrophic Failure
      8. References
    8. Index
    9. SPECIAL OFFER: Upgrade this ebook with O’Reilly