Microsoft SQL Server 2008 High Availability -- Table of Contents -- Microsoft SQL Server 2008 High Availability -- Credits -- Foreword -- About the Author -- Acknowledgement -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 1. Understanding Windows Domains, Domain Users, and SQL Server Security -- Windows domains and domain users -- Understanding SQL Server Security -- Windows authentication -- What is clustering? -- How clustering works -- MSDTC -- Types of clusters -- Single-instance Cluster -- Multi-instance Cluster -- Multi-site Failover Cluster -- Guest Failover Clustering -- Components of clustering -- Shared disk array -- Internet Small Computer System Interface -- Storage Area Network (SAN) -- Redundant Array of Independent Disks -- The Quorum -- Public and Private Network -- Summary -- 2. Implementing Clustering -- What is Hyper-V? -- Installation prerequisites for SQL Server 2008 R2 -- Hardware requirements -- Software requirements -- Operating system requirements -- Server role and feature -- IP addresses -- Network name -- Shared disks -- Installing a Single-instance Failover Cluster -- Adding a node to an SQL Server failover cluster -- Installing the SQL Server failover cluster using the command prompt -- Installing SQL Server failover cluster using the Configuration file -- Installing Multi-instance (Active/Active) Failover Cluster -- Adding a node to a SQL Server failover cluster -- Configuration -- Write caching -- File shares -- Maximum memory size -- Minimum memory size -- Preferred owners -- LooksAlive -- IsAlive -- Restart -- Affect the Group.

Dependencies -- File share -- Anti Virus tool -- Summary -- 3. Snapshot Replication -- Components of the replication -- Types of replication -- Snapshot Replication -- Transactional Replication -- Merge Replication -- Peer-to-Peer Replication -- Replication topologies -- How replication works -- Prerequisites for Snapshot Replication -- Installing -- Configuring Distributor and Publisher -- Creating publication -- Creating subscription -- Configuring Snapshot Replication -- Snapshot Agent -- Distribution Agent -- Maintenance jobs -- Agent history clean up: distribution -- Distribution clean up: distribution -- Expired subscription clean up -- Reinitialize subscriptions having data validation failures -- Replication agents check-up -- Replication monitoring refresher for distribution -- Configuring publication properties -- Configuring alerts -- Snapshot Agent parameters -- Adding and dropping an article and a column to the existing publication using T-SQL -- Summary -- 4. Transactional Replication -- Prerequisites for Transactional Replication -- Working with Transactional Replication -- Installing Transactional Replication -- Creating new publication for Transactional Replication -- Creating subscription for Transactional Replication -- Installing publication and subscription using T-SQL -- Configuring Transactional Replication -- Parameters to be configured with Distribution Agent profile -- Summary -- 5. Merge Replication -- Merge Replication usages -- How Merge Replication works -- Prerequisites for Merge Replication -- Installing Merge Replication -- Creating publication -- Creating subscription -- Configuration -- Configuring publication using T-SQL -- Configuring the Subscriber using T-SQL -- Creating alternate synchronization partner using T-SQL -- Dropping an alternate synchronization partner using T-SQL -- Uninstalling subscription.

Configuring download-only articles -- Configuring alerts using SSMS -- Summary -- 6. Peer-to-Peer Replication -- What is Peer-to-Peer Replication? -- How Peer-to-Peer Replication works -- Prerequisites for Peer-to-Peer Replication -- Installing Peer-to-Peer Replication -- Configuration -- Configuring alerts -- Removing a node from Peer-to-Peer Replication -- Adding SQL Server 2005 as a Peer-to-Peer node -- Summary -- 7. Log Shipping -- What is Log Shipping? -- How Log Shipping works -- Prerequisites for Log Shipping -- Installing Primary Server -- Setting up the secondary database -- Setting Monitor Server instance -- Configuration -- Setting up Primary Server for Log Shipping -- Setting up Secondary Server -- Summary -- 8. Database Mirroring -- What is Database Mirroring -- Different components of the Database Mirroring -- How Database Mirroring works -- Asynchronous a.k.a. High Performance mode -- Synchronous a.k.a. High Safety mode -- Prerequisites -- Installing Database Mirroring -- Preparing for Database Mirroring -- Installing Database Mirroring -- Starting Database Mirroring -- Manual or forced failover -- Adding the Witness Server -- Configuration using T-SQL -- Monitoring the Database Mirroring status using Database Mirroring Monitor -- Configuring the threshold for Database Mirroring -- Summary -- A. Troubleshooting -- Chapter 2: Implementing Clustering -- Common troubleshooting - installation -- Network binding order -- Problem while adding a second node -- Common troubleshooting and tips - resources -- Chapter 3: Snapshot Replication -- Troubleshooting using Replication Monitor (RM) -- Chapter 4: Transactional Replication -- Chapter 5: Merge Replication -- Index on columns used in filters -- LOB data types -- Avoid using identity column as primary key -- Frequently asked questions -- Chapter 6: Peer-to-Peer Replication.

Chapter 7: Log Shipping -- Frequently asked questions -- Chapter 8: Database Mirroring -- B. External References -- Chapter 1: Understanding Windows Domain, Domain Users, and SQL Server Security -- Chapter 2: Implementing Clustering -- Chapter 3: Snapshot Replication -- Chapter 4: Transactional Replication -- Chapter 5: Merge Replication -- Chapter 6: Peer-to-Peer Replication -- Chapter 7: Log Shipping -- Chapter 8: Database Mirroring -- Index.