Backup and Recovery
This information packed course will help determine if you have a sufficient backup strategy and restore plan OR help you build one from scratch.
Plan to recover from fires, floods, ransomware, and many other disaster scenarios.
In this course we dive into real life stories, RTO and RPO lesson with examples, what might you need to restore from, types of backups, configuring backups with maintenance plans, restoring from backups, ransomware considerations, building restore script and other backup tools.
Course Curriculum:
- Introducing the Course
- Prerequisites
- Horror Stories
- Success Stories
- RTO and RPO
- What Might You Need To Restore From?
- Types of SQL Server Backups
- Types of Backups Quiz
- Configuring Backups with Maintenance Plans
- Demo – Full Backups
- Demo – Differential Backups
- Demo – Transaction Log Backups
- Demo – Viewing your backup history
- RTO and RPO Example Scenarios
- Restoring Your Backups
- Restoring Backups – Intro Lesson
- Demo – Restoring a Full Backup
- Demo – Restoring From a Dropped or Damaged Table
- Demo – Restoring to Another Server
- Considerations for Ransomware
- A Common Story
- Ransomware Statistics
- Ransomware Video Lesson
- Building your restore script
- Supporting Files – restoreLogChain
- Supporting Files – Clean up files.ps1S
- The easier way
- Other Backup Tools
- AZCOPY to move backups to Azure Storage
- Backing up to an Azure Blob Storage URL
- Wrap-up and Review
- Course Review
- What is the worst thing that can happen?
Getting Help from Steve and the Team
Contact us for your Free 30 minute consultation ORschedule your appointment now.