The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P96: 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. | Monitoring and Troubleshooting Chapter 10 457 Figure Object Explorer Because the error log displays in a separate window as shown in Figure you can view the current log as well as the six most recent error logs. To view the older log files simply uncheck the current log and check the log file you wish to view. To view the details of a log entry simply select the entry in the window on the upper right to view the details in the lower right pane. If you are unable to connect to SQL Server because it s down or too busy to allow other sessions to connect you can access the log file directly on the hard drive. 458 Chapter 10 Monitoring and Troubleshooting Figure SQL Server Error Log The SQL Server ERRORLOG file is written in plain text and can be opened in notepad textpad or any other text editor. By default the ERRORLOG file is located in the C Program Files Microsoft SQL Server MSSQL MSSQL Log folder. If you are unsure where the log file is stored you can look at the startup parameters of the SQL Server service. The easiest way to do this is to open the SQL Server Configuration Manager and select the properties of the service. Then select the Advanced tab as shown in Figure . In the Startup Parameters entry you will see the -e parameter. This is the full path to the ERRORLOG file. As you can see in Figure the ERRORLOG file for this instance is located at d mssql MSSQL Log ERRORLOG. Monitoring and Troubleshooting Chapter 10 459 Figure SQL Server Configuration Manager SQL Server SQL2008 Properties Log On Service FILESTREAM Advanced Dump Directory D mssql MSSQL 10. SQL2008 MSS _ Error Reporting Yes File Version Install Path C Program Files Microsoft SQL Se Instance ID Language 1033 Registry Root Software Microsoft Microsoft SQL Running under 64 bit OS No Service Pack Level 0 SQL States 2099205 -dD mssql Startup Parameters Stock Keeping Unit ID Stock Keeping Unit Name .
