![]() Inside the Storage Engine: Using DBCC PAGE and DBCC IND to find out if page splits ever roll back ? I use this as my reference for output from DBCC IND and DBCC PAGE.Common bad advice around disaster recovery ? Search for “the best way to create a test corrupt database”.If you’d like to go straight to the source: It just took me a little bit to understand how to use the hex editor and make sure I was doing it properly, so I thought I’d put down the steps I used here in detail. References, and thanks to Paul RandalĮverything I’m doing here I learned from Paul Randal’s blog posts. ![]() If you corrupt a system database, you may be reinstalling SQL Server. If you corrupt the wrong pages in a user database, you may not be able to bring it back online. Only use this at home, in a dark room, alone, when not connected to your workplace, or anything you’ve ever cared about. Or anywhere near production, or anything important. This post gives you the tools in a simple, step by step fashion, to create different types of corruption so that you can practice resolving them.īig Disclaimer: Do not run this in production. When things go badly, you want to be prepared. You only want to do this on a test database, in a land far far away from your customers, for the purpose of practicing dealing with corruption. It is no fun at all on any data, or any server, that you care about. If you aren’t familiar with corruption, corruption is bad. Not how to fix anything, just how to break it. This Post Tells You How To Corrupt a SQL Server Database with a Hex Editor in Gruesome DetailĪnd that’s all this post tells you.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |