In this day-long pre-con session we will explore the various high availability options within SQL Server including how to configure these various options. We will be looking into Windows and SQL Server Clustering (including what is needed for a geographically dispersed cluster), Database Mirroring, The Always On Availability Group features, and SQL Server Log Shipping.
In addition to working through these high availability options, we will be discussing the most important part of high availability configuration, making sure that you know how to select the correct high availability solution. After completing this high availability pre-con workshop, you'll be able to make the correct decision about which high availability decision to deploy, as well as how to correctly deploy the selected solution.
You will learn:
- About Failover Clusters
- About Database Mirroring
- About AlwaysOn Availability Groups