Introducing the Course | Stedmans SQL School

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
Backup Types

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)
Testing your Backups (1:35)
Risks of Not Testing Restores (2:32)

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)
Testing Your Restore Scripts (6:14)

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

Introducing the Course

Complete and Continue

Lesson Content Locked

Your session expired. Please sign in again to continue.

Login