Conference corruption demo scripts and example corrupt databases

This blog post explains the demo scripts and databases I've posted to cover all the Corruption Survival Techniques and DBCC CHECKDB sessions I've presented at conferences this year. There are two zip files you need to download: the example corrupt databases (36-MB zip) (and this one if you're on 2008) and the demo scripts. These are also both available through our past events pages.

The databases zip contains the following databases:

• DemoDataPurity
  • 192-MB SQL Server 2005 database with a single 2570 (data purity) error
• DemoFatalCorruption1
  • 1-MB SQL Server 2005 database with a corrupt system table (that allows CHECKDB to complete)
• DemoFatalCorruption2
  • 1-MB SQL Server 2005 database with a corrupt system table (that terminates CHECKDB)
• DemoNCIndex
  • 192-MB SQL Server 2005 database with a bunch of nonclustered index corruptions
• DemoRestoreOrRepair
  • 1-MB SQL Server 2005 database with a page checksum failure (in fact a zero'd out page)
• DemoCorruptMetadata
  • 1-MB SQL Server *2000* database with corrupt syscolumns table

The scripts zip contains the following directories:

• 1 – Fatal Errors
  • This makes use of the DemoFatalCorruption1 and DemoFatalCorruption2 databases. The FatalErrors.sql script has the steps to follow and see this blog post for a complete walk-through.
• 2 – NC Indexes
  • This makes use of the DemoNCIndex database. The NCIndexCorruption.sql script has the steps to follow and see this blog post for a complete walk-through.
• 3 – Data Purity
  • This makes use of the DemoDataPurity database. The DataPurityCorruption.sql script has the steps to follow. I'll blog more details on this script sometime in the next week (and then update this post).
• 4 – Metadata
  • This makes use of the DemoCorruptMetadata database. The CorruptMetadata.sql script has the steps to follow and see this blog postfor a complete walk-through.
• 5 – Restore or Repair
  • This makes use of the DemoRestoreOrRepair database. There's a setup script (01CreateRestoreOrRepair.sql) and two demo scripts –FixUsingPageRestore.sql and FixUsingRepair.sql. I'll blog more details on these scripts sometime in the next week (and then update this post).
• 6 – Suspect Database
  • This demo doesn't come with a corrupt database – you create your own one. The SuspectDatabase.sql script has the steps to follow and see this blog post for a complete walk-through.

Enjoy!