2013
Pluralsight
Paul Randal
3h 52m
English
Database corruption happens all the time, all over the world.
Learn how to easily and automatically detect corruption, and then how to recover from corruption with the minimum of downtime and data loss using restore or repair, applicable to anyone who is responsible for SQL Server databases, from SQL Server 2005 onward
Database corruption happens all the time, all over the world.
When it happens in your environment, do you know what to do? Will you realize you have corruption?
Written and presented by the person who wrote SQL Server's consistency checking and repair tools, this course will show you what you need to know to detect and recover from most cases of database corruption.
The course starts by explaining why timely corruption detection is so important, and then investigates the various causes of database corruption.
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 course then moves on to interpreting the output from consistency checks so you'll know when you have corruption in your environment, plus whether and how the corruption limits your recovery options or not.
Finally, the course ends with modules that describe and demonstrate how to recover from corruption using simple restore techniques and simple repair techniques.
Packed with a wealth of information and practical, easy-to-follow demonstrations, this course will prepare you to detect and recover from database corruption when it happens to you.
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.
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Why is This Course Important 3.85 MB 0:02:38 128kbps 172.00 1024x768 15 frames/second 01.Introduction
02.What Can Happen to an Unprepared DBA Confronted by Corruption 1.29 MB 0:00:48 128kbps 205.00 1024x768 15 frames/second 01.Introduction
03.Things That Many People Try First 4.02 MB 0:02:55 128kbps 136.00 1024x768 15 frames/second 01.Introduction
04.Real-World Example 4.78 MB 0:03:30 128kbps 127.00 1024x768 15 frames/second 01.Introduction
05.Practice Makes Perfect 1.89 MB 0:01:20 128kbps 122.00 1024x768 15 frames/second 01.Introduction
06.Root Cause Analysis 3.25 MB 0:02:16 128kbps 155.00 1024x768 15 frames/second 01.Introduction
07.Why Can I Teach This Course 2.51 MB 0:01:40 128kbps 169.00 1024x768 15 frames/second 01.Introduction
08.Course Structure 2.54 MB 0:01:43 128kbps 175.00 1024x768 15 frames/second 01.Introduction
01.Introduction 1.23 MB 0:00:51 128kbps 107.00 1024x768 15 frames/second 02.Causes of Database Corruption-n
02.How Does Corruption Occur (1) 2.58 MB 0:01:46 128kbps 155.00 1024x768 15 frames/second 02.Causes of Database Corruption-n
03.How Does Corruption Occur (2) 3.82 MB 0:02:40 128kbps 139.00 1024x768 15 frames/second 02.Causes of Database Corruption-n
04.How Does Corruption Occur (3) 3.22 MB 0:02:27 128kbps 68.00 1024x768 15 frames/second 02.Causes of Database Corruption-n
05.Increase Protection Using RAID 3.97 MB 0:02:56 128kbps 130.00 1024x768 15 frames/second 02.Causes of Database Corruption-n
06.What Does NOT Cause Corruption 1.60 MB 0:01:09 128kbps 104.00 1024x768 15 frames/second 02.Causes of Database Corruption-n
07.Corruption Propagation to Remote Servers 3.83 MB 0:02:31 128kbps 202.00 1024x768 15 frames/second 02.Causes of Database Corruption-n
08.Disappearing Corruption 3.15 MB 0:02:05 128kbps 201.00 1024x768 15 frames/second 02.Causes of Database Corruption-n
09.Summary 1.29 MB 0:00:59 128kbps 62.00 1024x768 15 frames/second 02.Causes of Database Corruption-n
01.Introduction 1.04 MB 0:00:43 128kbps 106.00 1024x768 15 frames/second 03.Detecting Page Corruption
02.Page Protection Options 1.45 MB 0:01:02 128kbps 118.00 1024x768 15 frames/second 03.Detecting Page Corruption
03.Torn-Page Detection (1) 2.98 MB 0:02:05 128kbps 158.00 1024x768 15 frames/second 03.Detecting Page Corruption
04.Torn-Page Detection (2) 1.07 MB 0:00:49 128kbps 60.00 1024x768 15 frames/second 03.Detecting Page Corruption
05.Page Checksums (1) 4.26 MB 0:02:58 128kbps 166.00 1024x768 15 frames/second 03.Detecting Page Corruption
06.Page Checksums (2) 2.95 MB 0:02:12 128kbps 87.00 1024x768 15 frames/second 03.Detecting Page Corruption
07.Demo - Checking and Setting Page Protection 7.11 MB 0:02:44 128kbps 383.00 1024x768 15 frames/second 03.Detecting Page Corruption
08.I-O Errors 2.17 MB 0:01:39 128kbps 76.00 1024x768 15 frames/second 03.Detecting Page Corruption
09.I-O Error Example 1.55 MB 0:00:58 128kbps 189.00 1024x768 15 frames/second 03.Detecting Page Corruption
10.Demo - I-O Error 10.0 MB 0:04:09 128kbps 357.00 1024x768 15 frames/second 03.Detecting Page Corruption
11.Read-Retry and Error 825 3.41 MB 0:02:12 128kbps 248.00 1024x768 15 frames/second 03.Detecting Page Corruption
12.Automatic Page Repair 2.79 MB 0:01:54 128kbps 188.00 1024x768 15 frames/second 03.Detecting Page Corruption
13.Memory Corruption 2.11 MB 0:01:25 128kbps 190.00 1024x768 15 frames/second 03.Detecting Page Corruption
14.Monitoring for I-O Errors 2.49 MB 0:01:47 128kbps 123.00 1024x768 15 frames/second 03.Detecting Page Corruption
15.Summary 1.57 MB 0:01:08 128kbps 105.00 1024x768 15 frames/second 03.Detecting Page Corruption
01.Introduction 1.30 MB 0:00:56 128kbps 105.00 1024x768 15 frames/second 04.Consistency Checking
02.Consistency Checks 1.75 MB 0:01:11 128kbps 162.00 1024x768 15 frames/second 04.Consistency Checking
03.Which Databases Should Be Checked 1.99 MB 0:01:22 128kbps 161.00 1024x768 15 frames/second 04.Consistency Checking
04.How to Run Consistency Checks 1.50 MB 0:01:02 128kbps 127.00 1024x768 15 frames/second 04.Consistency Checking
05.Demo - SQL Agent Job to Run Consistency Checks 3.70 MB 0:02:12 128kbps 199.00 1024x768 15 frames/second 04.Consistency Checking
06.Demo - Viewing SQL Agent Job History 5.72 MB 0:02:18 128kbps 565.00 1024x768 15 frames/second 04.Consistency Checking
07.How Often Should Consistency Checks Be Run 3.65 MB 0:02:36 128kbps 131.00 1024x768 15 frames/second 04.Consistency Checking
08.Can You Ever Get a Guarantee 2.50 MB 0:01:50 128kbps 120.00 1024x768 15 frames/second 04.Consistency Checking
09.How to Consistency Check a VLDB 1.72 MB 0:01:15 128kbps 110.00 1024x768 15 frames/second 04.Consistency Checking
10.Consistency Checks Using Another Server (1) 1.64 MB 0:01:09 128kbps 154.00 1024x768 15 frames/second 04.Consistency Checking
11.Consistency Checks Using Another Server (2) 1.74 MB 0:01:10 128kbps 176.00 1024x768 15 frames/second 04.Consistency Checking
12.Backup Checksums 1.83 MB 0:01:17 128kbps 151.00 1024x768 15 frames/second 04.Consistency Checking
13.Demo - Backup Checksums 19.2 MB 0:06:41 128kbps 514.00 1024x768 15 frames/second 04.Consistency Checking
14.Backups Checksums vs. Consistency Checks 1.56 MB 0:01:04 128kbps 141.00 1024x768 15 frames/second 04.Consistency Checking
15.Consistency Checking Survey (1) 2.83 MB 0:01:50 128kbps 161.00 1024x768 15 frames/second 04.Consistency Checking
16.Consistency Checking Survey (2) 1.60 MB 0:01:06 128kbps 115.00 1024x768 15 frames/second 04.Consistency Checking
17.Summary 1.16 MB 0:00:47 128kbps 115.00 1024x768 15 frames/second 04.Consistency Checking
01.Introduction 1.97 MB 0:01:20 128kbps 134.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
02.DBCC CHECKDB (1) 3.48 MB 0:02:25 128kbps 163.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
03.DBCC CHECKDB (2) 3.61 MB 0:02:34 128kbps 133.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
04.Other DBCC CHECK+ Commands (1) 3.30 MB 0:02:22 128kbps 162.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
05.Other DBCC CHECK+ Commands (2) 1.68 MB 0:01:13 128kbps 115.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
06.Other DBCC CHECK+ Commands (3) 829 KB 0:00:36 128kbps 74.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
07.What Exactly Does DBCC CHECKDB Do (1) 3.17 MB 0:02:19 128kbps 128.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
08.What Exactly Does DBCC CHECKDB Do (2) 1.24 MB 0:00:54 128kbps 111.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
09.Does DBCC CHECKDB Run During Startup 2.29 MB 0:01:30 128kbps 189.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
10.Demo - Viewing Last-Known-Good Time 5.59 MB 0:02:12 128kbps 472.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
11.DBCC CHECK+ Options (1) 1.99 MB 0:01:25 128kbps 130.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
12.DBCC CHECK+ Options (2) 2.61 MB 0:01:53 128kbps 150.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
13.Demo - DBCC CHECK+ Options 12.7 MB 0:05:27 128kbps 1053.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
14.How Are DBCC CHECK+ Commands Online 3.48 MB 0:02:18 128kbps 170.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
15.How Long Will DBCC CHECKDB Take To Run 3.04 MB 0:02:12 128kbps 138.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
16.Potential Problems With DBCC CHECKDB (1) 3.16 MB 0:02:08 128kbps 173.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
17.Potential Problems With DBCC CHECKDB (2) 2.24 MB 0:01:39 128kbps 92.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
18.Breaking Up Consistency Checks Over Time 2.35 MB 0:01:36 128kbps 180.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
19.Summary 850 KB 0:00:36 128kbps 80.00 1024x768 15 frames/second 05.DBCC CHECKDB and Related Commands
01.Introduction 1.58 MB 0:01:06 128kbps 108.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
02.First Signs of Corruption... 1.25 MB 0:00:56 128kbps 64.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
03.Running DBCC CHECKDB 2.78 MB 0:01:56 128kbps 156.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
04.Where Does DBCC CHECKDB Output Go 1.66 MB 0:01:07 128kbps 165.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
05.Demo - Example DBCC CHECKDB Output 12.3 MB 0:04:51 128kbps 532.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
06.Interpreting DBCC CHECKDB Output (1) 1.15 MB 0:00:48 128kbps 130.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
07.Interpreting DBCC CHECKDB Output (2) 2.24 MB 0:01:32 128kbps 183.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
08.Demo - Fatal Error Examples 11.1 MB 0:04:12 128kbps 748.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
09.Interpreting DBCC CHECKDB Output (3) 2.47 MB 0:01:41 128kbps 170.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
10.Interpreting DBCC CHECKDB Output (4) 2.40 MB 0:01:38 128kbps 184.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
11.Demo - Various Corruption Examples 20.9 MB 0:06:26 128kbps 984.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
12.Restore vs. Repair (1) 2.28 MB 0:01:33 128kbps 179.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
13.Restore vs. Repair (2) 1.64 MB 0:01:07 128kbps 181.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
14.Exporting Data to a New Database 1.32 MB 0:00:58 128kbps 105.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
15.Summary 1.34 MB 0:00:59 128kbps 91.00 1024x768 15 frames/second 06.Interpreting DBCC CHECKDB Output
01.Introduction 1.22 MB 0:00:52 128kbps 106.00 1024x768 15 frames/second 07.Simple Restore Techniques
02.Recovering Using Backups 1.64 MB 0:01:07 128kbps 166.00 1024x768 15 frames/second 07.Simple Restore Techniques
03.Backup Types (1) 1.97 MB 0:01:23 128kbps 153.00 1024x768 15 frames/second 07.Simple Restore Techniques
04.Backup Types (2) 2.29 MB 0:01:38 128kbps 144.00 1024x768 15 frames/second 07.Simple Restore Techniques
05.Backup Validation Survey 1.15 MB 0:00:47 128kbps 109.00 1024x768 15 frames/second 07.Simple Restore Techniques
06.How to Restore 1.62 MB 0:01:10 128kbps 121.00 1024x768 15 frames/second 07.Simple Restore Techniques
07.Continuity of The Log Backup Chain 3.00 MB 0:01:48 128kbps 206.00 1024x768 15 frames/second 07.Simple Restore Techniques
08.Restore Options 2.58 MB 0:01:45 128kbps 181.00 1024x768 15 frames/second 07.Simple Restore Techniques
09.Restoring an Entire Database to a Point-in-Time 1.60 MB 0:01:07 128kbps 147.00 1024x768 15 frames/second 07.Simple Restore Techniques
10.Demo - Restore Options and Point-in-Time Restore 16.3 MB 0:05:44 128kbps 469.00 1024x768 15 frames/second 07.Simple Restore Techniques
11.Tail-of-the-Log Backups 3.17 MB 0:02:05 128kbps 216.00 1024x768 15 frames/second 07.Simple Restore Techniques
12.Demo - Tail-of-the-Log Backups 9.45 MB 0:03:08 128kbps 529.00 1024x768 15 frames/second 07.Simple Restore Techniques
13.Recovering With Full, Differential, and Log Backups 1.68 MB 0:01:09 128kbps 143.00 1024x768 15 frames/second 07.Simple Restore Techniques
14.Falling Back on Log Backups 2.11 MB 0:01:25 128kbps 140.00 1024x768 15 frames/second 07.Simple Restore Techniques
15.Determining The Restore Sequence 2.08 MB 0:01:22 128kbps 193.00 1024x768 15 frames/second 07.Simple Restore Techniques
16.Demo - Determining The Restore Sequence 26.1 MB 0:09:59 128kbps 942.00 1024x768 15 frames/second 07.Simple Restore Techniques
17.Restoring to Non-Enterprise Edition 3.43 MB 0:02:14 128kbps 245.00 1024x768 15 frames/second 07.Simple Restore Techniques
18.Summary 1.40 MB 0:01:02 128kbps 98.00 1024x768 15 frames/second 07.Simple Restore Techniques
01.Introduction 1.55 MB 0:01:04 128kbps 108.00 1024x768 15 frames/second 08.Simple Repair Techniques
02.How Does Repair Work 2.84 MB 0:02:02 128kbps 128.00 1024x768 15 frames/second 08.Simple Repair Techniques
03.Running Repair 2.13 MB 0:01:29 128kbps 148.00 1024x768 15 frames/second 08.Simple Repair Techniques
04.Repair Options 1.05 MB 0:00:46 128kbps 93.00 1024x768 15 frames/second 08.Simple Repair Techniques
05.Beware of REPAIR_ALLOW_DATA_LOSS 1.64 MB 0:01:11 128kbps 142.00 1024x768 15 frames/second 08.Simple Repair Techniques
06.Examples of Repairs 1.73 MB 0:01:19 128kbps 96.00 1024x768 15 frames/second 08.Simple Repair Techniques
07.Misconceptions Around Repair 3.92 MB 0:02:50 128kbps 133.00 1024x768 15 frames/second 08.Simple Repair Techniques
08.Demo - Running Repair 22.2 MB 0:06:47 128kbps 823.00 1024x768 15 frames/second 08.Simple Repair Techniques
09.Manually Fixing Nonclustered Indexes 1.62 MB 0:01:06 128kbps 178.00 1024x768 15 frames/second 08.Simple Repair Techniques
10.Demo - Manually Fixing Nonclustered Indexes 14.4 MB 0:04:55 128kbps 696.00 1024x768 15 frames/second 08.Simple Repair Techniques
11.Manually Fixing Data Purity Errors 1.77 MB 0:01:17 128kbps 146.00 1024x768 15 frames/second 08.Simple Repair Techniques
12.Demo - Manually Fixing Data Purity Errors 15.9 MB 0:05:13 128kbps 2172.00 1024x768 15 frames/second 08.Simple Repair Techniques
13.If You Are Forced to Use Repair... 1.48 MB 0:01:00 128kbps 156.00 1024x768 15 frames/second 08.Simple Repair Techniques
14.Course Summary 2.10 MB 0:01:27 128kbps 153.00 1024x768 15 frames/second 08.Simple Repair Techniques
Download File Size:374.3 MB
|
