Posts
1. Click Start -> Programs -> Microsoft
SQL Server 2008/2012 -> Configuration
Tools -> SQL Server
Configuration Manager
2. In SQL Server Configuration Manager, click SQL Server Services on the left side and then right click on SQL Server (MSSQLSEVER) and select Properties from the drop down as shown below. For a named instance, right click on the appropriate SQL Server (INSTANCENAME) service.
3. In SQL Server (MSSQLSERVER) Properties window click on the Advanced tab and then expand the drop down next to Startup Parameters. The location of SQL Server Error Log file is mentioned next to the "-e" startup parameter
Navigate to the physical file location and open it or u can also use SQL query to get log details
EXEC sp_readerrorlog
Reference :
http://www.mssqltips.com/sqlservertip/2506/identify-location-of-the-sql-server-error-log-file/
2. In SQL Server Configuration Manager, click SQL Server Services on the left side and then right click on SQL Server (MSSQLSEVER) and select Properties from the drop down as shown below. For a named instance, right click on the appropriate SQL Server (INSTANCENAME) service.
3. In SQL Server (MSSQLSERVER) Properties window click on the Advanced tab and then expand the drop down next to Startup Parameters. The location of SQL Server Error Log file is mentioned next to the "-e" startup parameter
Navigate to the physical file location and open it or u can also use SQL query to get log details
EXEC sp_readerrorlog
No comments:
Post a Comment