Microsoft SQL Server 2008 High Availability with Clustering and Database Mirroring

Name: Microsoft SQL Server 2008 High Availability with Clustering and Database Mirroring
Availability: OutOfStock
ISBN: 9780071498135

ISBN-10: 0071498133

ISBN-13: 9780071498135

Edition: 2010

Authors: Michael Otey

List price: $42.00

30 day, 100% satisfaction guarantee!

Out of stock

Buy from Amazon

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Implement robust database clustering and mirroring solutions Featuring practical management procedures and realistic case studies, this new volume provides a concise roadmap for implementing clustering and database mirroring in SQL Server 2008. You will learn practical steps to ensure zero database loss, avoid system downtime, and provide instant data backups.Written by the technical director for SQL Server Magazine, Microsoft SQL Server 2008 High Availability With Clustering Andamp; Database Mirroring details the latest database and server failure prevention techniques.And You will find hands-on strategies for managing both clusters and database mirroring in a real-world environment.

Book details

List price: $42.00
Copyright year: 2010
Publisher: McGraw-Hill Education
Publication date: 1/7/2010
Binding: Paperback
Pages: 304
Size: 7.25" wide x 9.00" long x 0.75" tall
Weight: 1.100
Language: English

Michael Otey is the Senior Technical Editor of SQL Server Magazine and Windows 2000 Magazine. He is also the President of TECA, a consulting and software development company in Portland, Oregon that specializes in Windows, SQL Server and AS/400 utilities. Michael has published numerous articles in SQL Server Magazine and Windows 2000 Magazine. He is the co-author of the SQL Server 7 Developer's Guide and the author of VB Answers! published by Osborne/McGraw-Hill. He is also the author of AS/400 Client Server Programming and the AS/400 Application Developer's Guide published by 29th Street Press. Michael has a B.S. in psychology from Lewis and Clark college and he enjoys running, playing…



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