Easy way to create a corrupt database for testing

Easy way to create a corrupt database for testing

  • Comments 2

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!

Leave a Comment
  • Please add 5 and 7 and type the answer here:
  • Post
Page 1 of 1 (2 items)