PacktLib: Microsoft SQL Server 2008 High Availability

Microsoft SQL Server 2008 High Availability

Credits

Foreword

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Preface

Understanding Windows Domains, Domain Users, and SQL Server Security

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

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

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

Transactional Replication

Prerequisites for Transactional Replication

Installing Transactional Replication

Installing publication and subscription using T-SQL

Configuring Transactional Replication

Summary

Merge Replication

Merge Replication usages

How Merge Replication works

Prerequisites for Merge Replication

Installing Merge Replication

Configuration

Summary

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

Log Shipping

What is Log Shipping?

How Log Shipping works

Prerequisites for Log Shipping

Setting Monitor Server instance

Configuration

Summary

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

Troubleshooting

Troubleshooting

Troubleshooting

Troubleshooting

Troubleshooting

Troubleshooting

Troubleshooting

Troubleshooting

External References

External References

External References

External References

External References

External References

External References

External References

External References