I’ll demonstrate corruption by editing a data file with a hex editor, then explain the more frequent real-life causes of corruption. You’ll learn why we can’t tell when it happens, so we have to spot it as quickly as practical, and then what to do when you find it.

8 Comments. Leave new

  • I’m going through all of the training video’s. Is it possible to have access to the “slides” for the video presentations?
    it would be way easier to use printed slides from the presentations that writing notes all the time and stopping the video.
    Thanks, Pat Adams

    Reply
    • PAdams – no, sorry, we don’t give out the slides for these. We’ve had some surprisingly awful things happen around people re-presenting our slides as their own material at conferences. (sigh) Only takes a few to ruin it, dagnabbit.

      Reply
      • I agree about slides, but at some point may you consider make a PDF for the transcript? Many not natives english speakers (like me) would appreciate having some print oriented material to follow the video, which is awesome, but not always does the recorded audio… I know, copy & paste, but I just say.

        Reply
  • Sorry for being a moron but, on a production server would you run the same dbcc checkdb methodologies on system databases as you would on user databases, also can you compress or verify system database backups? I don’t seem to be able to find straight answers on this. Many thanks

    Reply
    • Thomas — yes, you’d want to run CHECKDB on system databases too. Most people don’t check tempdb, though.

      For verifying them, do you mean running restore with verify only, or actually restoring them to a different server? If you want to restore them to a different server to test, you’d need to rename them so they don’t conflict with the resident system databases.

      I’ll leave the compression question up to your endeavoring DBA mind. That should be easy enough for you to test 😉

      Thanks!

      Reply
      • Awesome thanks for the guidance, I have a test server setup so I can now try this all out (and have fun breaking things) many thanks

        Reply
    • Thomas – yes, I’d check system databases just like I’d check user databases because they can be corrupt, too.

      Can you compress or verify system backups – well, I’m going to turn that into a question: why not just try it? You can run experiments like that fairly quickly, probably even faster than it took to type the comment. 😀

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu