Practical SQL Server High Availability and Disaster Recovery

Supporting high availability and disaster recovery are without a doubt some of the most fundamental skill-sets necessary to being a successful senior level DBA. Whether you work in a multi-million dollar enterprise or a “strapped for cash” start-up, this course will compare and contrast the many features, techniques, and concepts available in SQL Server to meet your individual needs.

Congratulations, you’re the DBA. Along with all the rights, privileges, and prestige that comes with that. It also means you are responsible for not only the uptime and guaranteed availability of your database servers but also the ability for any of those servers to quickly recovery from any disaster imaginable. Supporting these two areas are without a doubt some of the most fundamental skill-sets necessary to being a successful senior level DBA. This course will compare and contrast the many features, techniques, and concepts available in SQL Server that will meet your individual needs whether you work in a multi-million dollar enterprise or a “strapped for cash” start-up.

• Understanding High Availability vs. Disaster Recovery 11mins
• Getting Familiar with the Transaction Log 19mins
• Taking Backups and Implementing Log Shipping 39mins
• Setting up Failover Clustering 59mins
• Supporting Legacy Mirrors 36mins
• Installing and Supporting AlwaysOn Availability Groups 64mins
• Understanding Additional Approaches 34mins
• Bringing It All Together 14mins