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 – 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
  • 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). – 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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