Skip to content

Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring

Spend $50 to get a free movie!

ISBN-10: 0071498133

ISBN-13: 9780071498135

Edition: 2010

Authors: Michael Otey

List price: $42.00
Blue ribbon 30 day, 100% satisfaction guarantee!
Out of stock
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
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.
Customers also bought

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