Introduction
  • Course Introduction
  • Instructor Introduction
  • Download Course Content Here
  • Tools We Need For The Course
  • The Three Categories of Critical Failures
  • Summary
SQL Server Startup Parameters
  • The Startup Parameters SQL Server Needs
  • Starting A Named Instance and Putting That Instance in Single User Mode
  • Troubleshooting The Failed Startup With Account Locked Out
  • Troubleshooting Failed Startup When Port Already In Use
  • Section 2 Summary
  • Section 2 Quiz
Error Log Dissection
  • Starting With A Clean Error Log
  • What's in The ErrorLog - Part 1
  • What's In The ErrorLog - Part 2
  • What's In The ErrorLog - Part 3
  • What's In The ErrorLog - Part 4
  • Summary
  • Section 3 Quiz.
SQL Server Recovery Troubleshooting
  • Restoring The Resource DB From Another Instance
  • Restoring The Master Database When Instance is Online
  • Recover Corrupt Model Database From Another Instance
  • Recovering A Lost SA Password
  • Repairing Tempdb Corruption
  • Rebuilding the Master Database
  • Summary
  • Quiz
Conclusion
  • Conclusion and Thank You