2013
Pluralsight
Paul Randal
3h 59m
English
Database corruption happens all the time, all over the world, and sometimes it's not so simple to deal with.
In this follow-on course from SQL Server: Detecting and Correcting Database Corruption, you'll learn the more advanced techniques that can lead to success in the most challenging corruption scenarios, applicable for more experienced SQL Server professionals, from SQL Server 2005 onward.
Database corruption happens all the time, all over the world, and sometimes it's not so simple to deal with.
The SQL Server: Detecting and Correcting Database Corruption course showed you what you need to know to detect and recover from most cases of database corruption and this course will take you to the next level of knowledge and capabilities.
The course starts by explaining in depth how DBCC CHECKDB processes databases and how you can tune the performance of DBCC CHECKDB to make it run as fast as possible.
You'll then learn about some undocumented DBCC commands, such as DBCC PAGE and DBCC WRITEPAGE, which can be invaluable when investigating and repairing corruption.
The course then moves on to dealing with transaction log corruption, such as using EMERGENCY mode and how to re-attach damaged databases, and more advanced restore techniques, including how to analyze the transaction log to find the point to restore to and how to perform a tail-of-the-log backup using a different SQL Server instance.
Finally, the course ends with advanced repair techniques, including how to deal with corrupt metadata by manually editing system tables, how to salvage data from backups and nonclustered indexes, and the ultimate in advanced recovery techniques: manually editing a database using DBCC WRITEPAGE.
Packed with a wealth of information and practical, easy-to-follow demonstrations, this course will prepare you for dealing with out-of-the-ordinary corruption problems.
The course is applicable to all SQL Server versions from SQL Server 2005 onward, and for more experienced SQL Server professionals.
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Why is This Course Important 1.73 MB 0:01:09 128kbps 126.00 1024x768 15 frames/second 01.Introduction
02.What Can Happen When Corruption Recovery Does Not Work 1.63 MB 0:01:04 128kbps 209.00 1024x768 15 frames/second 01.Introduction
03.Real-World Example 3.61 MB 0:02:39 128kbps 139.00 1024x768 15 frames/second 01.Introduction
04.Practice Makes Perfect 1.99 MB 0:01:23 128kbps 134.00 1024x768 15 frames/second 01.Introduction
05.Root Cause Analysis 3.25 MB 0:02:16 128kbps 155.00 1024x768 15 frames/second 01.Introduction
06.Why Can I Teach This Course 2.51 MB 0:01:40 128kbps 169.00 1024x768 15 frames/second 01.Introduction
07.Course Structure 1.65 MB 0:01:07 128kbps 156.00 1024x768 15 frames/second 01.Introduction
01.Introduction 1.36 MB 0:00:58 128kbps 107.00 1024x768 15 frames/second 02.DBCC CHECKDB Internals and Performance
02.What Exactly Does DBCC CHECKDB Do 6.74 MB 0:04:53 128kbps 140.00 1024x768 15 frames/second 02.DBCC CHECKDB Internals and Performance
03.Fact Processing (1) 4.36 MB 0:02:59 128kbps 189.00 1024x768 15 frames/second 02.DBCC CHECKDB Internals and Performance
04.Fact Processing (2) 3.57 MB 0:02:43 128kbps 79.00 1024x768 15 frames/second 02.DBCC CHECKDB Internals and Performance
05.Fact Processing (3) 1.85 MB 0:01:22 128kbps 72.00 1024x768 15 frames/second 02.DBCC CHECKDB Internals and Performance
06.Batch Processing 3.96 MB 0:02:39 128kbps 199.00 1024x768 15 frames/second 02.DBCC CHECKDB Internals and Performance
07.Parallelism (1) 3.26 MB 0:02:02 128kbps 226.00 1024x768 15 frames/second 02.DBCC CHECKDB Internals and Performance
08.Parallelism (2) 1.24 MB 0:00:55 128kbps 89.00 1024x768 15 frames/second 02.DBCC CHECKDB Internals and Performance
09.Nonclustered Index Checks 4.32 MB 0:02:53 128kbps 168.00 1024x768 15 frames/second 02.DBCC CHECKDB Internals and Performance
10.Making DBCC CHECKDB Go Faster (1) 2.66 MB 0:01:51 128kbps 170.00 1024x768 15 frames/second 02.DBCC CHECKDB Internals and Performance
11.Making DBCC CHECKDB Go Faster (2) 3.07 MB 0:02:04 128kbps 139.00 1024x768 15 frames/second 02.DBCC CHECKDB Internals and Performance
12.Making DBCC CHECKDB Go Faster (3) 3.10 MB 0:02:03 128kbps 187.00 1024x768 15 frames/second 02.DBCC CHECKDB Internals and Performance
13.Making DBCC CHECKDB Go Faster (4) 2.79 MB 0:01:52 128kbps 186.00 1024x768 15 frames/second 02.DBCC CHECKDB Internals and Performance
14.Summary 1.52 MB 0:01:05 128kbps 89.00 1024x768 15 frames/second 02.DBCC CHECKDB Internals and Performance
01.Introduction 1.18 MB 0:00:49 128kbps 107.00 1024x768 15 frames/second 03.Useful Undocumented DBCC Commands
02.DBCC IND 1.99 MB 0:01:21 128kbps 146.00 1024x768 15 frames/second 03.Useful Undocumented DBCC Commands
03.DBCC PAGE 2.22 MB 0:01:35 128kbps 150.00 1024x768 15 frames/second 03.Useful Undocumented DBCC Commands
04.Demo - DBCC IND and DBCC PAGE 27.8 MB 0:08:51 128kbps 1207.00 1024x768 15 frames/second 03.Useful Undocumented DBCC Commands
05.DBCC DBINFO 1.47 MB 0:01:05 128kbps 90.00 1024x768 15 frames/second 03.Useful Undocumented DBCC Commands
06.DBCC DBTABLE 2.10 MB 0:01:31 128kbps 120.00 1024x768 15 frames/second 03.Useful Undocumented DBCC Commands
07.Demo - DBCC DBINFO and DBCC DBTABLE 27.4 MB 0:06:26 128kbps 4390.00 1024x768 15 frames/second 03.Useful Undocumented DBCC Commands
08.DBCC WRITEPAGE 4.11 MB 0:02:45 128kbps 199.00 1024x768 15 frames/second 03.Useful Undocumented DBCC Commands
09.Demo - Creating Corruption Using a Hex Editor 6.25 MB 0:02:16 128kbps 504.00 1024x768 15 frames/second 03.Useful Undocumented DBCC Commands
10.Demo - Introducing DBCC WRITEPAGE 11.2 MB 0:04:18 128kbps 566.00 1024x768 15 frames/second 03.Useful Undocumented DBCC Commands
11.Demo - DBCC WRITEPAGE Examples 20.9 MB 0:07:09 128kbps 1230.00 1024x768 15 frames/second 03.Useful Undocumented DBCC Commands
12.Summary 1.29 MB 0:00:54 128kbps 115.00 1024x768 15 frames/second 03.Useful Undocumented DBCC Commands
01.Introduction 1.52 MB 0:01:04 128kbps 107.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
02.Database States (1) 2.46 MB 0:01:44 128kbps 150.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
03.Database States (2) 2.02 MB 0:01:23 128kbps 148.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
04.Damaged-Missing Log With Clean Shutdown 2.67 MB 0:01:37 128kbps 205.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
05.Demo - Recreating the Log 8.21 MB 0:03:19 128kbps 515.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
06.Damaged-Missing Log Without Clean Shutdown 1.31 MB 0:00:54 128kbps 148.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
07.EMERGENCY Mode 2.51 MB 0:01:47 128kbps 142.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
08.EMERGENCY-Mode Repair 3.29 MB 0:02:12 128kbps 208.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
09.Demo - EMERGENCY-Mode Repair 11.4 MB 0:04:56 128kbps 468.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
10.Demo - Unrepairable Corruption in EMERGENCY-Mode 14.9 MB 0:03:45 128kbps 1616.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
11.Detached SUSPECT Database 3.31 MB 0:02:13 128kbps 177.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
12.Demo - Detached SUSPECT Database 14.8 MB 0:05:05 128kbps 480.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
13.Demo - Detached SUSPECT Database with Non-Standard File IDs 18.3 MB 0:06:15 128kbps 514.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
14.Damaged Log of Attached Database 2.53 MB 0:01:41 128kbps 175.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
15.Summary 1.47 MB 0:01:04 128kbps 110.00 1024x768 15 frames/second 04.Dealing With Transaction Log Problems
01.Introduction 1.72 MB 0:01:15 128kbps 105.00 1024x768 15 frames/second 05.Advanced Restore Techniques
02.What If SQL Server is Unavailable 2.28 MB 0:01:35 128kbps 173.00 1024x768 15 frames/second 05.Advanced Restore Techniques
03.Demo - Hack-Attach Tail-of-the-Log Backup 11.2 MB 0:03:55 128kbps 522.00 1024x768 15 frames/second 05.Advanced Restore Techniques
04.Page Restore 1.94 MB 0:01:21 128kbps 115.00 1024x768 15 frames/second 05.Advanced Restore Techniques
05.Demo - Simple Page Restore 16.1 MB 0:05:13 128kbps 663.00 1024x768 15 frames/second 05.Advanced Restore Techniques
06.Demo - Failed Page Restore 11.8 MB 0:03:14 128kbps 1702.00 1024x768 15 frames/second 05.Advanced Restore Techniques
07.Piecemeal and Partial Restores 3.30 MB 0:02:15 128kbps 175.00 1024x768 15 frames/second 05.Advanced Restore Techniques
08.Demo - Partial Restore 13.9 MB 0:05:09 128kbps 1087.00 1024x768 15 frames/second 05.Advanced Restore Techniques
09.Demo - Piecemeal Restore 6.91 MB 0:02:38 128kbps 407.00 1024x768 15 frames/second 05.Advanced Restore Techniques
10.Restoring Corrupt Backups 2.61 MB 0:01:45 128kbps 172.00 1024x768 15 frames/second 05.Advanced Restore Techniques
11.Demo - Restoring Corrupt Backups 13.1 MB 0:04:17 128kbps 807.00 1024x768 15 frames/second 05.Advanced Restore Techniques
12.Looking Into Log Backups 3.64 MB 0:02:26 128kbps 196.00 1024x768 15 frames/second 05.Advanced Restore Techniques
13.Restoring to a Log Sequence Number 1.71 MB 0:01:07 128kbps 169.00 1024x768 15 frames/second 05.Advanced Restore Techniques
14.Demo - Using fn_dump_dblog and LSN Restore 21.1 MB 0:06:54 128kbps 779.00 1024x768 15 frames/second 05.Advanced Restore Techniques
15.Restoring System Databases (1) 1.67 MB 0:01:09 128kbps 137.00 1024x768 15 frames/second 05.Advanced Restore Techniques
16.Restoring System Databases (2) 2.64 MB 0:01:43 128kbps 201.00 1024x768 15 frames/second 05.Advanced Restore Techniques
17.Demo - Restoring master 9.21 MB 0:03:08 128kbps 763.00 1024x768 15 frames/second 05.Advanced Restore Techniques
18.Summary 1.63 MB 0:01:13 128kbps 90.00 1024x768 15 frames/second 05.Advanced Restore Techniques
01.Introduction 1.28 MB 0:00:55 128kbps 104.00 1024x768 15 frames/second 06.Advanced Repair Techniques
02.Is Repair Guaranteed to Work 4.25 MB 0:02:57 128kbps 171.00 1024x768 15 frames/second 06.Advanced Repair Techniques
03.Metadata Corruption 5.97 MB 0:04:02 128kbps 226.00 1024x768 15 frames/second 06.Advanced Repair Techniques
04.Demo - Enabling the Dedicated Admin Connection 3.81 MB 0:01:53 128kbps 323.00 1024x768 15 frames/second 06.Advanced Repair Techniques
05.Demo - Upgraded Corrupt Metadata 17.0 MB 0:06:21 128kbps 551.00 1024x768 15 frames/second 06.Advanced Repair Techniques
06.Demo - Metadata Corruption 12.2 MB 0:04:11 128kbps 532.00 1024x768 15 frames/second 06.Advanced Repair Techniques
07.Rebuilding System Table Indexes 2.16 MB 0:01:30 128kbps 141.00 1024x768 15 frames/second 06.Advanced Repair Techniques
08.Demo - Corrupt System Table Indexes 12.3 MB 0:03:10 128kbps 864.00 1024x768 15 frames/second 06.Advanced Repair Techniques
09.Using Older Backups and Repair 1.49 MB 0:01:02 128kbps 128.00 1024x768 15 frames/second 06.Advanced Repair Techniques
10.Demo - Using Older Backups and Repair 18.1 MB 0:05:25 128kbps 1334.00 1024x768 15 frames/second 06.Advanced Repair Techniques
11.Reconstructing Data From Nonclustered Indexes 2.25 MB 0:01:25 128kbps 205.00 1024x768 15 frames/second 06.Advanced Repair Techniques
12.Demo - Reconstructing Data From Nonclustered Indexes 22.8 MB 0:07:21 128kbps 650.00 1024x768 15 frames/second 06.Advanced Repair Techniques
13.Using DBCC PAGE to Navigate Table Structures 3.77 MB 0:02:34 128kbps 172.00 1024x768 15 frames/second 06.Advanced Repair Techniques
14.Demo - Using DBCC PAGE to Navigate Table Structures 17.8 MB 0:06:01 128kbps 624.00 1024x768 15 frames/second 06.Advanced Repair Techniques
15.The Ultimate Advanced Recovery 3.85 MB 0:02:34 128kbps 229.00 1024x768 15 frames/second 06.Advanced Repair Techniques
16.Demo - Manual Repair Using DBCC WRITEPAGE 44.4 MB 0:13:41 128kbps 1325.00 1024x768 15 frames/second 06.Advanced Repair Techniques
17.Any Other Ways to Salvage Data 1.85 MB 0:01:21 128kbps 99.00 1024x768 15 frames/second 06.Advanced Repair Techniques
18.Course Summary 3.05 MB 0:02:00 128kbps 162.00 1024x768 15 frames/second 06.Advanced Repair Techniques
Download File Size:500.24 MB
|
