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: Advanced Corruption Recovery Techniques

Course Summary

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 data


  • +

    Course Syllabus

    ● Introduction
        ◦ Why is This Course Important?
        ◦ What Can Happen When Corruption Recovery Does Not Work?
        ◦ Real-World Example
        ◦ Practice Makes Perfect
        ◦ Root Cause Analysis
        ◦ Why Can I Teach This Course?
        ◦ Course Structure
    ● DBCC CHECKDB Internals and Performance
        ◦ Introduction
        ◦ What Exactly Does DBCC CHECKDB Do?
        ◦ Fact Processing (1)
        ◦ Fact Processing (2)
        ◦ Fact Processing (3)
        ◦ Batch Processing
        ◦ Parallelism (1)
        ◦ Parallelism (2)
        ◦ Nonclustered Index Checks
        ◦ Making DBCC CHECKDB Go Faster (1)
        ◦ Making DBCC CHECKDB Go Faster (2)
        ◦ Making DBCC CHECKDB Go Faster (3)
        ◦ Making DBCC CHECKDB Go Faster (4)
        ◦ Summary
    ● Useful Undocumented DBCC Commands
        ◦ Introduction
        ◦ DBCC IND
        ◦ DBCC PAGE
        ◦ Demo: DBCC IND and DBCC PAGE
        ◦ DBCC DBINFO
        ◦ DBCC DBTABLE
        ◦ Demo: DBCC DBINFO and DBCC DBTABLE
        ◦ DBCC WRITEPAGE
        ◦ Demo: Creating Corruption Using a Hex Editor
        ◦ Demo: Introducing DBCC WRITEPAGE
        ◦ Demo: DBCC WRITEPAGE Examples
        ◦ Summary
    ● Dealing With Transaction Log Problems
        ◦ Introduction
        ◦ Database States (1)
        ◦ Database States (2)
        ◦ Damaged/Missing Log With Clean Shutdown
        ◦ Demo: Recreating the Log
        ◦ Damaged/Missing Log Without Clean Shutdown
        ◦ EMERGENCY Mode
        ◦ EMERGENCY-Mode Repair
        ◦ Demo: EMERGENCY-Mode Repair
        ◦ Demo: Unrepairable Corruption in EMERGENCY-Mode
        ◦ Detached SUSPECT Database
        ◦ Demo: Detached SUSPECT Database
        ◦ Demo: Detached SUSPECT Database with Non-Standard File IDs
        ◦ Damaged Log of Attached Database
        ◦ Summary
    ● Advanced Restore Techniques
        ◦ Introduction
        ◦ What If SQL Server is Unavailable?
        ◦ Demo: Hack-Attach Tail-of-the-Log Backup
        ◦ Page Restore
        ◦ Demo: Simple Page Restore
        ◦ Demo: Failed Page Restore
        ◦ Piecemeal and Partial Restores
        ◦ Demo: Partial Restore
        ◦ Demo: Piecemeal Restore
        ◦ Restoring Corrupt Backups
        ◦ Demo: Restoring Corrupt Backups
        ◦ Looking Into Log Backups
        ◦ Restoring to a Log Sequence Number
        ◦ Demo: Using fn_dump_dblog and LSN Restore
        ◦ Restoring System Databases (1)
        ◦ Restoring System Databases (2)
        ◦ Demo: Restoring master
        ◦ Summary
    ● Advanced Repair Techniques
        ◦ Introduction
        ◦ Is Repair Guaranteed to Work?
        ◦ Metadata Corruption
        ◦ Demo: Enabling the Dedicated Admin Connection
        ◦ Demo: Upgraded Corrupt Metadata
        ◦ Demo: Metadata Corruption
        ◦ Rebuilding System Table Indexes
        ◦ Demo: Corrupt System Table Indexes
        ◦ Using Older Backups and Repair
        ◦ Demo: Using Older Backups and Repair
        ◦ Reconstructing Data From Nonclustered Indexes
        ◦ Demo: Reconstructing Data From Nonclustered Indexes
        ◦ Using DBCC PAGE to Navigate Table Structures
        ◦ Demo: Using DBCC PAGE to Navigate Table Structures
        ◦ The Ultimate Advanced Recovery
        ◦ Demo: Manual Repair Using DBCC WRITEPAGE

        ◦ Any Other Ways to Salvag


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management and Networks & IT Infrastructure Community

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