SQL log file

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  December 5, 2011 at 5:48 pm

  #391040

  Is there a way from SQL management studio to find out what is the file path for SQL server log.txt file stored?

  Thanks

• Pradyothana Shastry

  SSCertifiable

  Points: 5211

  More actions

  December 5, 2011 at 11:41 pm

  #1417120

  declare @dir nvarchar(4000)

  exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer',N'SQLArg1', @dir output, 'no_output'

  if @dir is null

  begin

  exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\Setup',N'SQLDataRoot', @dir output, 'no_output'

  select @dir = @dir + N'\LOG'

  end

  select @dir

  OR

  SELECT SERVERPROPERTY('ErrorLogFileName')

  
  - Pradyothana http://www.msqlserver.com

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  December 6, 2011 at 5:24 am

  #1417264

  its listed right at the start of the errorlog after a sql restart (not just a errorlog cycle)

  ---------------------------------------------------------------------

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  December 6, 2011 at 8:35 am

  #1417425

  I tried the following:

  D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

  I recieved the following:

  (No column name)

  D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

  The following code:

  SELECT SERVERPROPERTY('ErrorLogFileName')

  Returns:

  (No column name)

  D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

  However the path of the error logs are:

  C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

  ?:unsure:

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/