| |
| |
Acknowledgments | |
| |
| |
Introduction | |
| |
| |
| |
Planning for High Availability | |
| |
| |
Defining High Availability | |
| |
| |
Factors Influencing Availability | |
| |
| |
Personnel Factors | |
| |
| |
Operational Factors | |
| |
| |
Technical Factors | |
| |
| |
| |
Implementing Windows Failover Clustering | |
| |
| |
| |
Windows Failover Clustering Architecture | |
| |
| |
Overview | |
| |
| |
Windows Failover Cluster Configurations | |
| |
| |
Two-Node Clusters | |
| |
| |
Multinode Clusters | |
| |
| |
Multisite Clusters | |
| |
| |
Windows Failover Cluster Components | |
| |
| |
Cluster Nodes | |
| |
| |
Cluster Service | |
| |
| |
Virtual IP Address and Cluster Name | |
| |
| |
Cluster Quorum | |
| |
| |
Services and Applications | |
| |
| |
Shared Storage | |
| |
| |
Additional Resources | |
| |
| |
New Failover Clustering Features in Windows Server 2008 | |
| |
| |
Cluster Validation | |
| |
| |
Simplified Cluster Setup and Management | |
| |
| |
Support for Cluster Shared Volumes | |
| |
| |
Support for GUID Partition Table Disks | |
| |
| |
Support for IPv6 | |
| |
| |
Support for Multiple Subnets | |
| |
| |
SQL Server 2008 Failover Clustering Support | |
| |
| |
| |
Configuring Failover Clustering | |
| |
| |
Configuring Windows Server 2008 Shared Storage | |
| |
| |
The iSCSI Network Connections | |
| |
| |
Configuring the Windows Server 2008 iSCSI Initiator | |
| |
| |
Adding the Failover Clustering Feature | |
| |
| |
Adding the Failover Cluster Feature with Server Manager | |
| |
| |
Configuring Failover Clustering | |
| |
| |
Running the Failover Cluster Manager | |
| |
| |
Validating the Cluster Configuration | |
| |
| |
Creating the Cluster Using the Create Cluster Wizard on Node 1 | |
| |
| |
| |
Configuring SQL Server Failover Clustering | |
| |
| |
Installing Microsoft Distributed Transaction Coordinator on the Cluster | |
| |
| |
Installing Server 2008 on the First Cluster Node | |
| |
| |
Installing Server 2008 on the Second Cluster Node | |
| |
| |
| |
Managing Failover Clustering | |
| |
| |
Managing the Cluster | |
| |
| |
Bringing a Clustered Service Offline | |
| |
| |
Bringing a Clustered Service Back Online | |
| |
| |
Pausing a Node | |
| |
| |
Resuming a Node | |
| |
| |
Performing a Manual Failover | |
| |
| |
Performing a Manual Failback | |
| |
| |
Configuring for Automatic Failback | |
| |
| |
Monitoring Failover Events | |
| |
| |
Backing Up the Cluster | |
| |
| |
Adding the Windows Backup Feature | |
| |
| |
Backing Up a Cluster Node | |
| |
| |
Restoring a Cluster Node | |
| |
| |
| |
Implementing Database Mirroring | |
| |
| |
| |
Database Mirroring Architecture | |
| |
| |
Database Mirroring Requirements | |
| |
| |
Database Mirroring Architecture | |
| |
| |
Database Mirroring Modes | |
| |
| |
High Safety Mode | |
| |
| |
High Performance Mode | |
| |
| |
Client Failover | |
| |
| |
Using Database Snapshots for Reporting | |
| |
| |
Combining Database Mirroring and Failover Clustering | |
| |
| |
| |
Configuring Database Mirroring | |
| |
| |
Database Mirroring Requirements | |
| |
| |
SQL Server System Requirements | |
| |
| |
SQL Server Database Server Requirements | |
| |
| |
Initializing Database Mirroring | |
| |
| |
Setting the Database Recovery Mode to Full | |
| |
| |
Perform a Full Database Backup on the Principal Server | |
| |
| |
Restore the Database Backup to the Mirror Server with Norecovery | |
| |
| |
Perform a Transaction Log Backup on the Principal Server | |
| |
| |
Restore the Log Database Backup on the Mirror with Norecovery | |
| |
| |
Configuring Mirroring on the Principal Server | |
| |
| |
Configuring the Client for Failover | |
| |
| |
| |
Managing Database Mirroring | |
| |
| |
Managing the Mirroring Session | |
| |
| |
Pausing Mirroring | |
| |
| |
Resume Mirroring | |
| |
| |
Performing a Manual Failover | |
| |
| |
Performing a Manual Failback | |
| |
| |
Monitoring Database Mirroring | |
| |
| |
Using the Database Mirroring Monitor | |
| |
| |
Using the sp_dbmonitorresults Stored Procedure | |
| |
| |
Verifying Your Database Mirroring Configuration | |
| |
| |
Listing SQL Server Endpoints | |
| |
| |
Listing the Mirroring Endpoint Information | |
| |
| |
| |
Implementing Hyper-V Virtualization and Live Migration | |
| |
| |
| |
Virtualization and Live Migration Architecture | |
| |
| |
An Overview of Virtualization | |
| |
| |
Virtual Machine Architecture | |
| |
| |
Microsoft Hyper-V Architecture | |
| |
| |
The Windows Server 2008 Hyper-V Role | |
| |
| |
Hyper-V Server 2008 | |
| |
| |
High Availability and Virtualization | |
| |
| |
Deployment and Disaster Recovery | |
| |
| |
Windows Failover Clustering and Virtualization | |
| |
| |
Quick Migration | |
| |
| |
Live Migration | |
| |
| |
Live Migration Architecture | |
| |
| |
Requirements for Live Migration | |
| |
| |
| |
Configuring Hyper-V Live Migration | |
| |
| |
Configuring Windows Server 2008 Shared Storage | |
| |
| |
The iSCSI Connection | |
| |
| |
Configuring the Windows Server 2008 iSCSI Initiator | |
| |
| |
Adding the Hyper-V Role | |
| |
| |
Adding the Failover Clustering Feature | |
| |
| |
Configuring Failover Clustering for Live Migration | |
| |
| |
Running the Failover Cluster Manager | |
| |
| |
Configuring Cluster Shared Volumes | |
| |
| |
| |
Configuring SQL Server with Hyper-V Live Migration | |
| |
| |
Creating a Hyper-V VM with Live Migration | |
| |
| |
Installing Windows Server 2008 on the VM | |
| |
| |
Installing SQL Server 2008 on the VM | |
| |
| |
Configuring the SQL Server VM for Live Migration | |
| |
| |
| |
Managing the Virtual SQL Server | |
| |
| |
Managing the Highly Available Virtual SQL Server | |
| |
| |
Virtual Machine Management Using the Hyper-V Manager | |
| |
| |
Virtual Machine Management Using the Failover Cluster Manager | |
| |
| |
Performing a Live Migration | |
| |
| |
Performing a Quick Migration | |
| |
| |
System Center Enterprise Suite | |
| |
| |
System Center Virtual Machine Manager 2008 R2 | |
| |
| |
Index | |