question

shamim007 avatar image
shamim007 asked

SQL Server agent error log

Hi Experts, This morning I got the error below. Why i am getting this? Why this is happening? Date 1/5/2017 10:07:32 AM Log SQL Server (Archive #1 - 1/5/2017 10:07:00 AM) Source spid60 Message Attempting to cycle error log. This is an informational message only; no user action is required.
sql-server-2008agenterror-log
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered
That's not really an error rather just an informational message (as stated) that someone or something is attempting to cycle the error log. Usually, this is done via a sql agent job at some regular interval such as at midnight every night. However, everybody's environment is different so your mileage may vary. Reference: https://www.brentozar.com/archive/2015/09/forgotten-maintenance-cycling-the-sql-server-error-log/ EDIT: This would hold true for both the error log as well as the agent log. Hope that helps!
6 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

shamim007 avatar image shamim007 commented ·
do i have to worry about it ?My SQL server Agent job error log Archive is #9 now .do i have to recycle them ?thanks for your help@JohnM
0 Likes 0 ·
JohnM avatar image JohnM commented ·
Your error log is set to keep 9 error logs. You shouldn't have to worry about other than if someone is attempting to manually recycle the log and you (assuming you are the DBA) aren't aware of it then I would investigate why they are manually doing so. Reference: https://msdn.microsoft.com/en-us/library/ms175488.aspx
0 Likes 0 ·
shamim007 avatar image shamim007 commented ·
thank you .in our environment we never get that before .why that error came now ?@johnM
0 Likes 0 ·
JohnM avatar image JohnM commented ·
Someone or something executed that commend. Either a SQL Agent job or some of other means.
0 Likes 0 ·
shamim007 avatar image shamim007 commented ·
what is the way i can find out how the command executed ?@JohnM
0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.