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?

  • Please explain corruption? There are so many ways to have a corrupt db Commented Nov 30, 2011 at 7:38
  • Corrupt as in a modified database schema (i.e. columns names, etc.) or as in broken dependencies and orphan records? Commented Nov 30, 2011 at 7:38
  • 2
    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). Commented Nov 30, 2011 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 Commented Nov 30, 2011 at 10:14
  • Sorry! Missed to add. Corruption in terms of orphaned records.
    – Shoban
    Commented Nov 30, 2011 at 10:34

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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