MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server: Detecting and Correcting Database Corruption

Course Summary

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 too


  • +

    Course Syllabus

    ● Introduction
        ◦ Why is This Course Important?
        ◦ What Can Happen to an Unprepared DBA Confronted by Corruption?
        ◦ Things That Many People Try First
        ◦ Real-World Example
        ◦ Practice Makes Perfect
        ◦ Root Cause Analysis
        ◦ Why Can I Teach This Course?
        ◦ Course Structure
    ● Causes of Database Corruption
        ◦ Introduction
        ◦ How Does Corruption Occur? (1)
        ◦ How Does Corruption Occur? (2)
        ◦ How Does Corruption Occur? (3)
        ◦ Increase Protection Using RAID
        ◦ What Does NOT Cause Corruption
        ◦ Corruption Propagation to Remote Servers
        ◦ Disappearing Corruption
        ◦ Summary
    ● Detecting Page Corruption
        ◦ Introduction
        ◦ Page Protection Options
        ◦ Torn-Page Detection (1)
        ◦ Torn-Page Detection (2)
        ◦ Page Checksums (1)
        ◦ Page Checksums (2)
        ◦ Demo: Checking and Setting Page Protection
        ◦ I/O Errors
        ◦ I/O Error Example
        ◦ Demo: I/O Error
        ◦ Read-Retry and Error 825
        ◦ Automatic Page Repair
        ◦ Memory Corruption
        ◦ Monitoring for I/O Errors
        ◦ Summary
    ● Consistency Checking
        ◦ Introduction
        ◦ Consistency Checks
        ◦ Which Databases Should Be Checked?
        ◦ How to Run Consistency Checks?
        ◦ Demo: SQL Agent Job to Run Consistency Checks
        ◦ Demo: Viewing SQL Agent Job History
        ◦ How Often Should Consistency Checks Be Run?
        ◦ Can You Ever Get a Guarantee?
        ◦ How to Consistency Check a VLDB?
        ◦ Consistency Checks Using Another Server (1)
        ◦ Consistency Checks Using Another Server (2)
        ◦ Backup Checksums
        ◦ Demo: Backup Checksums
        ◦ Backups Checksums vs. Consistency Checks
        ◦ Consistency Checking Survey (1)
        ◦ Consistency Checking Survey (2)
        ◦ Summary
    ● DBCC CHECKDB and Related Commands
        ◦ Introduction
        ◦ DBCC CHECKDB (1)
        ◦ DBCC CHECKDB (2)
        ◦ Other DBCC CHECK* Commands (1)
        ◦ Other DBCC CHECK* Commands (2)
        ◦ Other DBCC CHECK* Commands (3)
        ◦ What Exactly Does DBCC CHECKDB Do? (1)
        ◦ What Exactly Does DBCC CHECKDB Do? (2)
        ◦ Does DBCC CHECKDB Run During Startup?
        ◦ Demo: Viewing Last-Known-Good Time
        ◦ DBCC CHECK* Options (1)
        ◦ DBCC CHECK* Options (2)
        ◦ Demo: DBCC CHECK* Options
        ◦ How Are DBCC CHECK* Commands Online?
        ◦ How Long Will DBCC CHECKDB Take To Run?
        ◦ Potential Problems With DBCC CHECKDB (1)
        ◦ Potential Problems With DBCC CHECKDB (2)
        ◦ Breaking Up Consistency Checks Over Time
        ◦ Summary
    ● Interpreting DBCC CHECKDB Output
        ◦ Introduction
        ◦ First Signs of Corruption...
        ◦ Running DBCC CHECKDB
        ◦ Where Does DBCC CHECKDB Output Go?
        ◦ Demo: Example DBCC CHECKDB Output
        ◦ Interpreting DBCC CHECKDB Output (1)
        ◦ Interpreting DBCC CHECKDB Output (2)
        ◦ Demo: Fatal Error Examples
        ◦ Interpreting DBCC CHECKDB Output (3)
        ◦ Interpreting DBCC CHECKDB Output (4)
        ◦ Demo: Various Corruption Examples
        ◦ Restore vs. Repair (1)
        ◦ Restore vs. Repair (2)
        ◦ Exporting Data to a New Database
       


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top