SQL Server: Detecting and Correcting Database Corruption

Name: SQL Server: Detecting and Correcting Database Corruption
Rating: 4.6 (16 reviews)

Find out how to easily and automatically detect corruption with minimal data loss in SQL Server 2019.

Last updated 11/2022

English

English [Auto],

What you'll learn

7 sections • 33 lectures • 2h 54m total length

What is the first thing to think about corruption ?3:32
What are the causes of corruption?6:03
Corruption that disappears?2:15
corruption never disappears, it remains persistent despite checks; creating an index with new data pages may conceal old corruption on index pages, so be vigilant.
Démo :IO/errors7:15
This demonstration shows three corruption-related errors, how Windows reads disk data, and how to identify and correct suspect pages by listing the database and page numbers for correction.
Démo : TORN PAGE DETECTION and PAGE CHECKSUM5:33
Démo : DBCC IND and DBCC PAGE6:00
Demonstrate using dbcc ind and dbcc page to inspect page allocation and index structures, including cluster indexes, heaps, and fragmentation, with deeper page analysis.

Verification of data consistency2:28
Learn to verify data consistency to detect corruption and maintain database integrity, using manual checks or automated weekly jobs to cover the entire database.
Démo : Creation of a job for consistency check4:48
Explanation on the CHECKDB3:57
Démo : Options on the CHECKDB10:13
The lecture demos SQL Server's checkdb options, comparing physical only versus full checks, explaining how CHECKDB validates data integrity, estimates free space, and uses database snapshots to balance performance.
Survey on the CHECKDB2:55
Démo : BACKUP WITH CHECKSUM4:27
Watch a demo of backup with checksum that detects and corrects page 147 corruption, demonstrating how checksums maintain data integrity with minimal performance impact.

The different techniques of RESTORE1:46
Explore different restoration techniques to recover from database corruption, restore to a specific time, and always back up the system database to ensure recoverability.
Démo : RESTORE LOGS4:27
Showcases a demo of restoring logs to recover a SQL Server database after a crash, using backups, differential backups, and a catalog in recovery mode.
Démo : RESTORE WITH STOPAT5:53
Demonstrates performing a point-in-time restore with the stopat option to recover data from backups and restore a SQL Server database to a precise moment.
Démo : RESTORE WITH STANDY6:10
Learn how to use restore with standby to perform point-in-time recovery, track restoration progress, and stop at a precise restore point using standby mode.
Démo : The TAIL LOG BACKUP6:07
Démo : How to RESTORE a single page4:21
This demo shows how to restore a single page in a multi-terabyte database, highlighting a restoration technique that saves hours and ensures page-level consistency with log-based restrictions.
Démo : Restauration from a LSN4:24
Démo: How to RESTORE the Master system database ?5:56
Démo: How to RESTORE all the systems databases ?6:40
Demonstrate restoring all SQL Server system databases after corruption, recreating the setup from backups, archiving components, and regaining administrator access to the instance.

Database corruption happens all the time, all over the world !!

When it happens in your environment, do you know what to do?

This 2-hour course will show you what you need to know to detect and repair most cases of database corruption.
The course begins by explaining why early detection of corruption is so important, and then examines the different causes of database corruption.
You will learn how to configure SQL Server to automatically detect when I/O errors occur.
You'll learn how to configure SQL Server to automatically detect when I/O errors occur, what consistency checks are, the DBCC commands to use to perform consistency checks, and how to configure SQL Server to perform consistency checks regularly.

The training in detail:

This course is aimed at all database administrators and developers who will learn how to react to a case of corruption.

Taking this course will help you to stand out technically from your colleagues, or during a job interview.
I also made sure that the videos don't exceed 10 minutes, so that it wouldn't be too soporific :)
The course is applicable for all SQL Server versions from SQL Server 2005 onward, and for anyone responsible for SQL Server databases with any level of experience.

Future Database Administrators (DBAs)
Students who want to start using SQL
Tech leads (CRM, Web etc...) who want to discover SQL
This course is aimed at all database administrators and developers who will learn how to react to a case of corruption.