Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Server Backup and Restore
Introduction
Introducing the Course (4:29)
Prerequisites
Horror Stories (8:39)
Success Stories (3:26)
Importance of good backups
Thank You (1:08)
How to get the most out of this course. (0:32)
RTO and RPO
RTO and RPO Video Lesson (13:30)
RTO and RPO
RTO and RPO quiz
What Might You Need To Restore From?
Video Lesson (13:58)
Cases that may cause you to need to restore
Types of SQL Server Backups
Video Lesson (8:16)
Types of Backups Quiz
Types of Backups
New Lesson
Configuring Backups with Maintenance Plans
Demo - Full Backups (13:34)
Demo - Differential Backups (5:48)
Demo - Transaction Log Backups (6:40)
Demo - Viewing your backup history (5:06)
RTO and RPO Example Scenarios
Video Lesson (8:41)
Restoring Your Backups
Restoring Backups - Intro Lesson (5:45)
Demo - Restoring a Full Backup (7:17)
Demo - Restoring From a Dropped or Damaged Table (13:18)
Demo - Restoring to Another Server (6:55)
Considerations for Ransomware
A Common Story (7:40)
Ransomware Statistics
Ransomware Video Lesson (8:55)
The importance of immutable storage
Building your restore script
Supporting Files - restoreLogChain
Supporting Files - Clean up files.ps1
The easier way (24:51)
Other Backup Tools
AZCOPY to move backups to Azure Storage (7:20)
Backing up to an Azure Blob Storage URL (4:32)
General Backup Notes
Using trace flag 3226 to silence backup messages. (5:26)
Trace flag 3226 details
Quiz 3226
Wrap Up and Review
Testing your backups - A gentle reminder
Course Review (1:40)
What is the worst thing that can happen? (1:32)
Other courses
Teach online with
Importance of good backups
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock