SQL Server Backup and Recovery Course

This complete course will help you determine if you have a sufficient backup strategy and restore plan OR will 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.

Contact us with questions about this course.


Backup and Recovery

Your Instructor, Steve Stedman


With over 34 years of SQL Server experience, Steve has done his share of performance tuning.

This course is taught by Steve Stedman with some help from other team members. A majority of the lessons are taught by Steve.

If you are having trouble grasping a concept, you can reach out to Steve through his mentoring program for help or more details.



One of the most important jobs of a DBA

When things go bad with hardware failure, or a ransomware attack, typically the most important thing a DBA can do to save the business is recovering from backups.

Too often I have received a call from a new customer asking for help. They were hit with ransomware and all their backups are destroyed. Sometimes it is a drive failure and their databases and backups were all on the say array.

One of the reasons that I created this course was to help teach the importance of planning for those scenarios before they happen instead of after they happen.

I really don't like to have to tell people that there is no recovery option, and that their backups were not sufficient for the crisis.

This course is designed to make it so that you don't every have to be in the position to tell your management that everything is lost and we can't restore.

Choose a Pricing Option

If you have a coupon code, you can apply that in the checkout page.

Curriculum

(click arrow below to extend curriculum)

  Introduction
Available in days
days after you enroll
  RTO and RPO
Available in days
days after you enroll
  What Might You Need To Restore From?
Available in days
days after you enroll
  Types of SQL Server Backups
Available in days
days after you enroll
  Configuring Backups with Maintenance Plans
Available in days
days after you enroll
  RTO and RPO Example Scenarios
Available in days
days after you enroll
  Restoring Your Backups
Available in days
days after you enroll
  Considerations for Ransomware
Available in days
days after you enroll
  Building your restore script
Available in days
days after you enroll
  Other Backup Tools
Available in days
days after you enroll
  General Backup Notes
Available in days
days after you enroll
  Wrap Up and Review
Available in days
days after you enroll