Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 5 down vote favorite
2

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
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
show 3 more comments

1 Answer

up vote 1 down vote

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

 
discard

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.