Detecting corruption | Stedmans SQL School

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Preparing for Corruption on SQL Server

Introduction

What causes database corruption? (6:59)
Real corruption stories (11:03)
Corruption Overview
HIdden Costs of Ignoring Corruption (3:20)
How to get the most out of this course. (0:32)

What can you do?

Preventing Corruption (15:38)
Reducing the risk of getting corruption (2:37)
Reducing the impact of Corruption (6:05)
Detecting corruption (5:23)
Homework
Additional cuases of Corruption, what you can do. (2:47)

What is what?

Ransomware and Corruption (3:47)
Corruption vs. Drive Failure (6:06)

Best Practices and Corruption

Role of backups in protecting against corruption (3:51)

What to do if you have corruption already?

Suggested Homework
What if you need help? (1:45)
REPAIR_ALLOW_DATA_LOSS warnings (4:08)

Database Corruption Challenge

Introduction Instructions
Challenge 1
Challenge 1 Solution
Challenge 2
Challenge 2 Solution #1
Challenge 2 Solution #2
Challenge 3
Challenge 3 Solution
Challenge 5
Challenge 5 Solution
Challenge 6
Challenge 6 Solution
Challenge 7
Challenge 7 Solution

Course Completion

When to call the experts? (3:57)

Teach online with

Detecting corruption

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock