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.
Practical SQL Server High Availability and Disaster Recovery
via Pluralsight
Most AI Pilots Fail to Scale. MIT Sloan Teaches You Why — and How to Fix It
AI Engineer - Learn how to integrate AI into software applications
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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.
Syllabus
- 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
Taught by
Russ Thomas