SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am working on a solution using which Site Admins can check and repair corrupt DB. I need sample corrupt DB for testing. Any ideas how to corrupt content database?

share|improve this question
Please explain corruption? There are so many ways to have a corrupt db – Wictor Wilen MCA MCM MVP Nov 30 '11 at 7:38
Corrupt as in a modified database schema (i.e. columns names, etc.) or as in broken dependencies and orphan records? – John Chapman Nov 30 '11 at 7:38
SP2010 already have a health rule with a "fix it" feature in CA for orphaned records (but, do not use it if you have SP1 + june/aug, since it does not care about the recycle bin). – Wictor Wilen MCA MCM MVP Nov 30 '11 at 7:41
As you are working on the solution, You might be knowing what kind of corruption it fixes and get a clue :). However, you should not try to modify the SharePoint DBs directly other then using SharePoint API – Amit Kumawat Nov 30 '11 at 10:14
Sorry! Missed to add. Corruption in terms of orphaned records. – Shoban Nov 30 '11 at 10:34

What a great question! I would recommend hitting the server with a high load (eg. automated tool), then restart SQL Server machine.

This will put the Databases in an inconsistent state and need to have integrity checks run on them when it restarts.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.