How do I corrupt my database?

Question

How do I corrupt my database?

sunny.tjk

SSCertifiable

Points: 5041
More actions
November 24, 2011 at 8:05 am

#247394

Could someone please explain how to corrupt my Adventureworks database? I'd like to test few DBCC commands.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

I think I saw Paul Randal blog about this a while ago. He may have been writing about the undocumented (I think) DBCC PAGE. Anyway, a well targeted internet search should dig it up for you.

John

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 2

Kalen Delaney (I think - I might be wrong) had a blog post explaining how to insert a few 0s into a data page. You could also open the AW database in a hex editor and insert a few random values, although you might have a job re-attaching the DB or restarting if your values are in the wrong place.

DBCC should then detect the corruption (assuming your setting is CHECKSUM) quite easily.

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 3

Courtesy of Phil Brammer here -> http://www.ssistalk.com/2010/05/04/sql-server-2005-how-to-introduce-data-corruption-without-trying/

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

From the master himself : http://sqlskills.com/BLOGS/PAUL/post/Sample-corrupt-databases-to-play-with.aspx

viiki.seth Ten Centuries Points: 1127 More actions · Answer 5

http://www.sqlskills.com/BLOGS/PAUL/post/TechNet-Radio-interview-on-database-corruption.aspx