System Log: Logs startup and shutdown info. Security Log: Records authentication information There are 3 helpful logs.Īpplication Log: Logs SQL Server and SQL Server Agent events The Event Viewer is an important resource for resolving SQL Server errors. To Open: Start > Run > SSMS > Expand Databases > Management SQL 2008 Location: %Program-Files%\Microsoft SQL Server\MSSQL10.x\MSSQL\LOG SQL 2005 Location: %Program-Files%\Microsoft SQL Server\MSSQL.1\MSSQL\LOG A new error log is created each time an instance of SQL Server is started Location: %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG This log shows which SQL server components were detected, the operating system environment, the command-line parameters that were specified, the values that were specified, and the overall status of each MSI and MSP file that was executed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |