Implementing High Availability and Replication in Microsoft SQL Server 2008 (10158)

Description:

This two-hour course provides you with the skills and knowledgerequired to understand the different high-availability and replicationtechnologies, which you can use to provide a robust SQL Server 2008infrastructure and distribute data across the enterprise. You willlearn how to implement high-availability solutions at the databaselevel by using database mirroring and transaction log shipping.

Topics covered in this course include:

• Introduction to High Availability
• Implementing Server Clustering
• Implementing Database Mirroring
• Introducing Log Shipping
• Introducing Replication
• Types of Replication

Student prerequisites:

To benefit from this course, the learner must be familiar with usingMicrosoft Windows. They must have knowledge of basic relationaldatabase concepts and querying data by using Transact-SQL. They must befamiliar with the role of a database administrator.

 

Objectives:

• Describe high availability.
• Implement server clustering.
• Implement database mirroring.
• Implement log shipping.
• Describe replication.
• Describe types of replication scenarios.

 

---

User Reviews

Not yet rated. You will need to follow this course before you can write a review.