4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

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.
Presented by John Huang at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    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.
  • Video
    The video is not available to view online.