Corruption 1: How it Happens, and How to Detect It
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.
- Backups 1: 3 Common Strategies
- Backups 2: Restores
- Backups 3: Setting Up Maintenance Plans
- Backups 4: Setting Up Ola Hallengren’s Maintenance Scripts
- Backups: Reading from Databases During Restores
- Configuration: Anti-Virus
- Configuration: Instant File Initialization
- Configuration: Lock Pages in Memory (LPIM)
- Configuration: Prepare for Emergencies with the Remote DAC
- Configuration: Sending Emails with Database Mail
- Configuration: sp_configure Settings
- Configuration: TempDB Files and Sizes
- Corruption 2: DBCC CHECKDB for VLDBs
- Maintenance: Agent Jobs
- Maintenance: Patches: Which Ones to Apply, When, and How
- Maintenance: Shrinking Files
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
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.
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.
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
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!
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
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. 😀
Awesome thanks for the info