Error logs not found in proper place

Question

Post reply

Error logs not found in proper place

Madhuchhanda Kundu

Old Hand

Points: 360
More actions
January 8, 2009 at 12:49 pm

#129039

Hi,
According to my config settings , my errorlog should be in this path -
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
But in that path the errorlog and teh sqlagent.out is missing.
However I can see the log in a grid view in management studio. But cannot determine anything as it is limited and yo can only drag so much the entries.
Please help.
thanks
Madhu

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 1

What do you see(path) under error log file path when you right click SQL Server Agent in SSMS?

MJ

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 2

And this file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG definitely doesn't exist?

Shamless self promotion - read my blog http://sirsql.net

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 3

You can find the path as the errorlog_file:

EXEC dbo.sp_get_sqlagent_properties

you can then change it with:

EXEC msdb.dbo.sp_set_sqlagent_properties @errorlog_file=N'D:\SrvApps\Microsoft SQL Server\MSSQL.5\MSSQL\LOG\SQLAGENT.OUT'

Madhuchhanda Kundu Old Hand Points: 360 More actions · Answer 4

Hi , thanks for the help but when I ran the command

EXEC msdb.dbo.sp_get_sqlagent_properties I got the resule as :-

auto_startmsx_server_namesqlagent_typestartup_accountsqlserver_restartjobhistory_max_rowsjobhistory_max_rows_per_joberrorlog_fileerrorlogging_levelerror_recipientmonitor_autostartlocal_host_serverjob_shutdown_timeoutcmdexec_accountregular_connectionshost_login_namehost_login_passwordlogin_timeoutidle_cpu_percentidle_cpu_durationoem_errorlogsysadmin_onlyemail_profileemail_save_in_sent_foldercpu_poller_enabledalert_replace_runtime_tokens

1NULL1BISQLuser@ROUNDPOINT.LOCAL110000100C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLAGENT.OUT3NULL1NULL15NULL0NULLNULL30106000NULLNULL100

But when I navigated to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLAGENT.OUT - the file was not there ...

also teh errorlog.txt is missing.

Please help.

Madhuchhanda

RPSQL Hall of Fame Points: 3229 More actions · Answer 5

Go to that physical server and try finding sqlagent.out and errorlog.txt files from windows search..May be that can help...just make sure that they are for the same instance....

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 6

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLAGENT.OUT is the file

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ is where you should find the logs, and ERRORLOG is the SQL log, there is no txt file

Shamless self promotion - read my blog http://sirsql.net

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 7

Look in the Windows Event Log and see what errors get logged if you try to restart the SQL Agent. If there aren't any, then recheck the LOG path again for the SQLAGENT.OUT. If there are errors logged, post them in this thread.

RPSQL Hall of Fame Points: 3229 More actions · Answer 8

Nicholas is right, the file should be there in log directory.:)