DBCC WritePage and Database Recovery
DBCC WritePage is an undocumented command that allows users to modify physical pages directly. It can be useful for database repairing when there are extreme situations where nothing can help you recover your data. It's a good tool for learning system internals. More importantly, you need to know this when others have already known.
In this session, We will explore some internals, break the integrity of the database , and recover it by this command. It could be the tool hurt yourself but I will demonstrate you how to keep yourself safe.
Sorry, there are no downloads available for this session.
John Huang, SQL MCM and MVP, has been working with SQL Server since 1994. He is an independent SQL Server consultant in Vancouver, BC, Canada specialized in complex data processing, data warehouse, performance tuning, and data recovery. He runs SQL PASS chapter in Victoria BC and spoke frequently at local SQL Server events, such as TechDays, DevTeach, TechFest, SQL Saturdays, as well as local PASS Chapters.
The video is not available to view online.