Wednesday, June 6, 2012

Exam 70-432: Week 3 - QotD

You may have noticed that I like to finish the Question of the Day part of each assignment early, so it's not hanging over my head all week. This week's submission is the QotD from June 1, 2012, and can be found at

SQL Server troubleshooting information can be found in Windows Event Logs. Information about SQL Server information can be viewed in all the logs below except which one?
    • Setup Event Logs
    • System Event log
    • Application Event logs
    • Security Event log
I fired up Books24x7 and looked in Microsoft SQL Server 2008: Administrator's Pocket Consultant, Second Edition. Chapter 14 has a section Working With the Event Logs that had this bullet point:
Windows has additional logs that can be helpful when tracking issues. If you are tracking security issues, start with the SQL Server event logs and also examine the Windows security log. If you are having trouble finding the source of a problem that is preventing proper operation of SQL Server, start with the SQL Server logs and also examine the Windows application and system logs. [emphasis mine]
So, by process of elimination, the correct answer is: the Setup Event Logs.

Reference:  Stanek, William R. (© 2009). Microsoft SQL Server 2008: administrator's pocket consultant, second edition. [Books24x7 version] Available from

No comments:

Post a Comment