PDF Add to WishList
SQL Server provides a full range of technologies that allow organizations to reduce downtime and maintain high levels of availability. In this training course, you gain experience using SQL Server 2014 AlwaysOn technologies for building a variety of high availability solutions, and learn how to implement failover clustering, log shipping, database mirroring, and peer-to-peer transactional replication.
Characterizing high availability
Planned vs. unplanned downtime
Defining components of a cluster
Preparing for Windows failover clustering
Planning for SQL Server failover clustering
Creating a SQL Server failover cluster
Preparing for a warm standby server
Implementing transaction log shipping
Switching to the standby server
Comparing mirroring architectures
Getting ready for mirroring
Mirroring a database
Employing a mirror for reporting
Enhancing the capabilities of database mirroring
Clustering and deployment
Selecting the appropriate strategies
Pulling it all together
Course Tuition Includes:
After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.
After-Course Computing Sandbox
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.
Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm
FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:
“The SQL Server High Availability course gave me the tools to meet any level of Service Level Agreement for our database applications.”
- S. Park, Database Architect
Alion Science & Technology