Introduction.
  • Course Overview
  • Course Content Can Be Downloaded Here
  • Instructor Introduction
Backups
  • Basic Database Architecture
  • What Are Recovery Models?
  • What Are The Backup Options For A SQL Server Database
  • Why The Full Backup Is So Important
  • Full Backup: Demonstration
  • Differential Backup: Demonstration
  • Transaction Log Backup: Demonstration
  • Creating A Very Simple Maintenance Plan For Our Backups
  • Removing Unwanted Backup and Log Files
  • Backup Strategies For Real World Boxes
  • Section 2 Summary
  • Section 2 Quiz
Updating Statistics
  • What Are Statistics?
  • Creating A Job To Update Our Statistics
  • Section 3 Summary
DBCC CHECKDB
  • How Does Corruption Happen?
  • How Often Should I Run Consistency Checks?
  • Creating Our Job To Run Consistency Checks
  • Section 4 Summary
  • Section 4 Quiz
Rebuild Indexes
  • What's The Difference Between Rebuilding and Reorganizing?
  • Rebuild VS Reorganize - Part 1
  • Rebuild VS Reorganize - Part 2
  • Section 5 Summary
  • Section 5 Quiz
Change The Default Growth Settings
  • Is The Default Really 1 MEG?
  • Section 6 Summary
Change Error Detection On Every Database
  • What's A CHECKSUM?
  • Let's Enable CHECKSUMS
  • Section 7 Summary
Catch Critical Errors In The Errorlog
  • The Errors Defined
  • Catching Critical Errors Before They Turn Into Disasters
  • Section 8 Summary
Testing Our Restores
  • Testing Our Backups Via A Restore
  • Section 9 Summary
Setting Up Database Mail
  • Configure Our Account and Our Profile
  • Configure Operator For Failed Jobs
  • Section 10 Summary
Conclusion
  • What We Covered In This Course