SQL Server Performance Forum – Threads Archive

Simulate consistency errors

I’m trying to set up integrity checks using sql litespeed and I want to be able to test it and see how it would react given that a database becomes corrupt and has consistency errors. There’s an option to do integrity checks before doing a complete backup. I want to be sure that it stops with failure before going on to the backup if there are consistency errors. I would really like to NOT wait until I have a corrupt database to find out how it reacts. Is there a way to simulate corruption or does an example of a corrupt database exist that I could attach to a test server and play with? If not, has anyone dealt with litespeed doing an integrity check before a complete backup with a corrupt DB? How did it respond? Thanks,
Chris

Deleting a row in the sysindexes system table with id >100 will result in a corrupted database. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Ah that is the easy way to corrupt the database, but make sure you’ve complete backup just in case to play around. For more information on this product you may try contact vendors. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] but efficient… – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

Thanks for your help. Great idea!

]]>