Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Practical SQL Server High Availability and Disaster Recovery
Introduction and Course Logistics
What this training is all about
How to get the most out of this training course
Understanding High Availability and Disaster Recovery Concepts
The Need for High Availability and Disaster Recovery (20:02)
Non-Technology Aspects of HA/DR (14:54)
The Alphabet Soup of HA/DR (42:05)
S.M.H.: Things You Didn't Know Were Part of HA/DR (35:35)
SQL Server Database Recovery Models
Different Database Recovery Models (29:04)
Database Recovery Models in Action
Transaction Log Internals
Inside the SQL Server Transaction Log (46:52)
Transaction Log Internals in Action
Database Backups
Different Backup Types (46:08)
Backup Strategies
Database Restore and Recovery
Restore and Recovery (18:27)
Factors Affecting Restore and Recovery (31:05)
High Availability Solutions in SQL Server
Failover Clustering (61:09)
Database Mirroring (50:06)
Availability Groups (32:04)
Disaster Recovery Solutions in SQL Server
Protecting System Databases (17:25)
Log Shipping (26:34)
Database Snapshots (21:47)
Implementing High Availability and Disaster Recovery in SQL Server
Planning HA/DR Solutions (26:46)
Combining HA/DR Solutions to Meet Business Requirements (17:52)
Backup and Restore Testing
Performing Failover Testing
Advanced HA/DR Scenarios and Troubleshooting
Multi-Site Failover Considerations (32:36)
Identifying and Dealing With Data Corruption in SQL Server (37:14)
Troubleshooting Common HA/DR Issues (33:01)
Best Practices and Real-World Examples
Best Practices for High Availability and Disaster Recovery
Case Studies of Successful (and Failed) HA/DR Implementations
Conclusion
Recap and Next Steps
Performing Failover Testing
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock