Upon completion of this course, the student will be able to: Identify different redundant data storage methods. Identify spare server options for fault tolerance. Discuss server cluster configurations. Determine the best failover support for your enterprise. Create a linked server and setup security for linked databases. Describe the functions of the microsoft Distributed Transaction Coordinator. Force conflict resolutions.
Unit 1: Managing Fault Tolerance
- Redundant Data Storage
- Server Clusters and Configurations
- Warm Spares
- Determining Failover Support
Unit 2: Managing Distributed Transactions
- Linked and Remote Servers
- Configuring MS DTC
- Two Phase Commit
- Forcing Conflict Resolution
- ACID Properties
Unit 3: Advanced Queries
- Distributed Queries
- Heterogeneous Replication
- Embedded SQL
- Open Data Services