SQL Server provides a full range of technologies that allow organizations to reduce downtime and maintain high levels of availability. In this SQL Server High Availability training course, you gain experience using SQL Server 2017 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.
TRAINING AT YOUR SITE
Our FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.
Feb 26 - 28 9:00 AM - 4:30 PM EST Ottawa / Online (AnyWare) Reserve Your Seat
Apr 8 - 10 9:00 AM - 4:30 PM EDT Washington, DC / Online (AnyWare) Reserve Your Seat
Aug 19 - 21 9:00 AM - 4:30 PM EDT Ottawa / Online (AnyWare) Reserve Your Seat
Sep 30 - Oct 2 9:00 AM - 4:30 PM EDT Washington, DC / Online (AnyWare) Reserve Your Seat
Guaranteed to RunWhen you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.
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
SQL Server High Availability allows 24 hour access to its database if any problem were to arise and you need immediate solutions.
The applicable version for this course is SQL Server 2017.
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want, including online training.