Microsoft SQL Server 2008 High Availability
This course has been retired. Check out the alternatives below
-
What do you get with a Packt Subscription?
- Instant access to this title and 7,500+ eBooks & Videos
- Constantly updated with 100+ new titles each month
- Breadth and depth in over 1,000+ technologies
-
Understanding Windows Domains, Domain Users, and SQL Server Security
- 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
- 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
- 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
- Transactional Replication
- Prerequisites for Transactional Replication
- Installing Transactional Replication
- Installing publication and subscription using T-SQL
- Configuring Transactional Replication
- Summary
-
Merge Replication
- Merge Replication
- Merge Replication usages
- How Merge Replication works
- Prerequisites for Merge Replication
- Installing Merge Replication
- Configuration
- Summary
-
Peer-to-Peer Replication
- 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
- Log Shipping
- What is Log Shipping?
- How Log Shipping works
- Prerequisites for Log Shipping
- Setting Monitor Server instance
- Configuration
- Summary
-
Database Mirroring
- 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