Windows domains and domain users
Understanding SQL Server Security
What is clustering?
How clustering works
MSDTC
Types of clusters
Components of clustering
The Quorum
Public and Private Network
Summary
Chapter 2: Implementing Clustering
What is Hyper-V?
Installation prerequisites for SQL Server 2008 R2
Installing a Single-instance 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
Configuration
Anti Virus tool
Summary
Chapter 3: Snapshot Replication
Components of the replication
Types of replication
Replication topologies
How replication works
Prerequisites for Snapshot Replication
Installing
Configuring Snapshot Replication
Snapshot Agent
Distribution Agent
Maintenance jobs
Configuring publication properties
Summary
Chapter 4: Transactional Replication
Prerequisites for Transactional Replication
Installing Transactional Replication
Installing publication and subscription using T-SQL
Configuring Transactional Replication
Summary
Chapter 5: Merge Replication
Merge Replication usages
How Merge Replication works
Prerequisites for Merge Replication
Installing Merge Replication
Configuration
Summary
Chapter 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
Adding SQL Server 2005 as a Peer-to-Peer node
Summary
Chapter 7: Log Shipping
What is Log Shipping?
How Log Shipping works
Prerequisites for Log Shipping
Setting Monitor Server instance
Configuration
Summary
Chapter 8: Database Mirroring
What is Database Mirroring
Different components of the Database Mirroring
How Database Mirroring works
Prerequisites
Installing Database Mirroring
Configuration using T-SQL
Summary
Appendix A: Troubleshooting
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
Appendix 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