Easy way to create a corrupt database for testing

Published Mar 23 2019 04:52 AM 157 Views
First published on MSDN on Mar 22, 2007

In previous posts I've explained how to use a hex editor to corrupt a database for testing and exploration. MVP Tony Rogerson has gone one step further by using bulk load to import a database into SQL Server and then create various corruptions using regular T-SQL. Checkout his *fantastic* blog post here and look through some of my earlier posts for details of on-disk data structures that you can corrupt.

Its very important that you try running CHECKDB on a known corrupt database so you can test whatever logic you have to notify you of database corruptions.

Have fun!

Version history
Last update:
‎Mar 23 2019 04:52 AM
Updated by: