Length:2.00 hours - Excluding labs and assessments
Published:Aug 25, 2009
Language:English
Audiences:IT Professional
Level:Advanced
Technology:Microsoft SQL Server 2008
Type:Course
Delivery method:Self-pace Course
This two-hour course provides you with the skills and knowledge required to understand the different high-availability and replication technologies, which you can use to provide a robust SQL Server 2008 infrastructure and distribute data across the enterprise. You will learn how to implement high-availability solutions at the database level 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
Describe high availability.
Implement server clustering.
Implement database mirroring.
Implement log shipping.
Describe replication.
Describe types of replication scenarios..
To benefit from this course, the learner must be familiar with using Microsoft Windows. They must have knowledge of basic relational database concepts and querying data by using Transact-SQL. They must be familiar with the role of a database administrator.