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?
8
-
Please explain corruption? There are so many ways to have a corrupt db– Wictor Wilen MCA MCM MVPCommented 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?– John ChapmanCommented Nov 30, 2011 at 7:38
-
2SP2010 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 MVPCommented 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– Amit KumawatCommented Nov 30, 2011 at 10:14
-
Sorry! Missed to add. Corruption in terms of orphaned records.– ShobanCommented Nov 30, 2011 at 10:34
|
Show 3 more comments
1 Answer
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.
