SQL Server provides a full range of technologies that allow organisations 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.
Learning Tree erbjuder kundanpassad utbildning hos er, öppna kurser i Stockholm, London eller Washington, möjlighet att delta via våra Anywhere centers (Malmö, Göteborg, Linköping, Stockholm eller Borlänge) eller olika former av e-learning med lärarstöd. Läs mer på www.learningtree.se/priser .
Characterising 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.
Questions about which training is right for you?08-506 668 00
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.