The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P93: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 442 Chapter 9 Managing Replication Self Test Quick Answer Key 1. D 11. C 2. A 12. B 3. D 13. D 4. D 14. B 5. C 15. A 6. B 16. C 7. B 17. C 8. C 18. B 9. A 19. A 10. A 20. D Chapter 10 MCTS SQL Server 2008 Exam 432 Monitoring and Troubleshooting Exam objectives in this chapter Service Troubleshooting Concurrency Issues Agent Issues Error Logs SQL Server Profiler Performance Monitor Exam objectives review 0 Summary of Exam Objectives 0 Exam Objectives Fast Track 0 Exam Objectives Frequently Asked Questions 0 Self Test 0 Self Test Quick Answer Key 443 444 Chapter 10 Monitoring and Troubleshooting Introduction There are quite a few moving parts when it comes to SQL Server and lots of things can go wrong. This chapter is meant to help you understand many of the issues and how to fix them. This chapter also shows you how to monitor your SQL Server to spot problems before they occur. Service Troubleshooting When dealing with a SQL Server that won t start the first place to look is the SQL ERRORLOG file. The ERRORLOG is misnamed as it doesn t just hold error information. It also holds all sorts of informational messages that the SQL Service writes out. If the SQL Service won t start most of the time the reason is written into the ERRORLOG file. The SQL Server also writes errors into the Windows Application log. In the event that the SQL Server cannot write to the ERRORLOG file it will still write to the Application log. Failure to read the ERRORLOG or Windows Application log is the most common mistake that people make when troubleshooting a SQL Service that won t start. The data in these logs isn t usually cryptic and it usually spells out the problem in plain English or the assigned system language . If a log says that the service can t find the path to the file then you have moved the master database. If it can t find the path to the ERRORLOG file you ll need to recreate the path to the log file. If the server can t access one or more data files it will be .
