Disclosure: when you buy through links on our site, we may earn an affiliate commission.

SQL Server: Detecting and Correcting Database Corruption

Find out how to easily and automatically detect corruption with minimal data loss in SQL Server 2019.
4.9
4.9/5
(6 reviews)
52 students
Created by

9.7

CourseMarks Score®

10.0

Freshness

9.5

Feedback

9.0

Content

Platform: Udemy
Video: 2h 54m
Language: English
Next start: On Demand

Table of contents

Description

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:
•What are common causes of corruption?
•How to check data consistency?
•How to repair in case of corruption?
•What to do in case of log corruption?
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.

You will learn

✓ What are the common causes of corruption?
✓ How to check the consistency of the data?
✓ How to repair in case of corruption?
✓ What to do when corrupting logs?
✓ Control corruption on your backup with BACKUP WITH CHECKSUM
✓ Explanation and demonstration on the CHECKDB
✓ Discover TORN PAGE DETECTION and PAGE CHECKSUM
✓ Discover DBCC IND and DBCC PAGE
✓ Learn how to repair a non-clustered index
✓ Recreating a log file by attaching a Database
✓ Repairing a database using the HACK ATTACH mode
✓ And discover all the techniques of RESTORE in case of corruption

Requirements

• Installation of SQL server on his workstation + studio management (SSMS)

This course is for

• 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.
Join the masterclass SQL Server course !
DBA, consultant and trainer on SQL Server technology for more than 15 years now, SQL is not for me a tool to work, but it has become a passion.
I am MSCA and MCT on SQL Server products.
I worked in many companies, including in particular at TF1 (first french channel) for 5 years on the most critical part the antenna part.
I thus pass on to you through my numerous courses my knowledge, and especially my experience, collected over these long years.

Platform: Udemy
Video: 2h 54m
Language: English
Next start: On Demand

Students are also interested in