SQL Server High Availability and Disaster Recovery (HA/DR)
What you'll learn
- By the end of the course, attendees will be able to understand the different SQL Server high availability and disaster recovery technologies - how they work and properly implement the right solution to address recovery objectives and service level agreements
Course content
Introduction2 lectures • 23min
- IntroductionPreview10:00
- The Need for High Availability and Disaster RecoveryPreview12:41
Non-Technology Aspects of High Availability and Disaster Recovery3 lectures • 42min
SQL Server Recovery Models3 lectures • 1hr 3min
SQL Server Database Backups2 lectures • 56min
SQL Server Transaction Log Internals3 lectures • 1hr 3min
SQL Server Database Restore and Recovery4 lectures • 1hr 55min
SQL Server System Databases2 lectures • 21min
SQL Server Database Mirroring3 lectures • 1hr 21min
SQL Server Log Shipping2 lectures • 38min
SQL Server Failover Clustering3 lectures • 2hr 51min
Requirements
- Attendees should have a basic understanding of managing and administering SQL Server databases
Description
This is a deep dive course on understanding how SQL Server works to effectively choose the right high availability and disaster recovery solution that will address every organization's need to protect digital assets. Packed with videos explaining concept and demos to reinforce the lessons, this course is what every IT professional needs to properly manage and protect a SQL Server database.
The course uses SQL Server 2012 for demonstrations. But the concepts still apply to later versions of SQL Server on Windows.
Who this course is for:
- Senior IT professionals
- SQL Server administrators
- Software developers who write applications for SQL Server
Instructor
![Edwin M Sarmiento](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.3 Instructor Rating
- 553 Reviews
- 4,513 Students
- 1 Course
Edwin M Sarmiento is a Filipino Microsoft Certified Master and a former 12-year Microsoft Data Platform MVP from Ottawa, Canada. He specializes in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases. He lives up to his primary mission statement – “To help people and organizations grow and develop their full potential as God has planned for them“
He's a regular contributor on the website MSSQLTips and has contributed to the SQL Server MVP Deep Dives book series - Volume 1 and Volume 2 - and one of the Technical Editors/Reviewers of the book SQL Server 2012 with PowerShell V3 Cookbook. He's actively involved in the SQL Server community by answering questions in Microsoft forums and speaking at conferences like SQLSaturday, SQLRally, SQLConnections, PASS Community Summit, Microsoft TechDays, Live360, Difinity Conference, DevTeach and other user group events.