HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How can I corrupt a table in SQL Server?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
cancorruptsqlhowservertable

Problem

I have to write a program that detects corrupted tables and tries to repair them. For this I need to corrupt tables regularly.

Is there anyway to corrupt tables manually?

Solution

Paul Randal has several Sample corrupt databases to play with:

-
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

Also, How to create a corrupt database using BULK INSERT/ UPDATE and BCP - SQL Server as a HEX editor.

Context

StackExchange Database Administrators Q#11198, answer score: 4

Revisions (0)

No revisions yet.