|
I need to test the behaviour of the application when the database is corrupted. So can somebody please tell what are the different ways to corrupt the database.
(comments are locked)
|
|
Paul Randal is the king of corruption. That's actually a complement, even though it sounded lousy. His blog articles have demoed how to "corrupt" SQL Server DB files on a number of occasions...here's one that I quickly googled: "Paul Randal is the king of corruption" - love it!
May 04 '12 at 08:51 PM
Kev Riley ♦♦
And now we all know how to corrupt da database. Paul published a blog post yesterday: http://www.sqlskills.com/blogs/paul/dbcc-writepage/
Feb 06 at 09:25 AM
DirkHondong
(comments are locked)
|
|
Also, there is a posting at: http://sqlblog.com/blogs/linchi_shea/archive/2007/08/29/how-to-corrupt-a-sql-server-2005-database.aspx . I am not sure it would be in line with with what you would like to accomplish.
(comments are locked)
|
|
Well, the simplest way is probably to detach a DB, then write a small application which just writes garbage into a few of the files. If you're feeling a bit more dangerous, you could always start a big write and unplug the drive data cable half way through (don't do this with a PATA drive though).
(comments are locked)
|
|
I was reminded of this question when I saw today's article on SQLServerCentral. How to Create a Corrupt SQL Server Database by Perry Whittle.
(comments are locked)
|
|
I have a corrupted MDF file and backup is not available. I have tried so many software but they didn’t works well. Anybody please suggest me what should I do and if there is any other way to recover my corrupted database. Dude, ask this as a separate question, not as an answer to an ages-old question on how to create a corrupted database. Going on what little you've said here, though, you've got problems.
Feb 06 at 11:39 AM
ThomasRushton ♦
(comments are locked)
|
Am I the only one that finds it amusing that the desired behavior is a corrupt database and the tag is "best-practice"?