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
 Attempting to cycle error log. This is an informational message only; no user action is required.
more ▼

asked Jan 06, 2017 at 06:40 PM in Default

avatar image

240 2 10

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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!

more ▼

answered Jan 06, 2017 at 06:48 PM

avatar image

14.5k 3 7 15

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

Jan 06, 2017 at 07:44 PM shamim007

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

Jan 06, 2017 at 08:17 PM JohnM

thank you .in our environment we never get that before .why that error came now ?@johnM

Jan 10, 2017 at 06:07 PM shamim007

Someone or something executed that commend. Either a SQL Agent job or some of other means.

Jan 10, 2017 at 07:06 PM JohnM

what is the way i can find out how the command executed ?@JohnM

Jan 11, 2017 at 01:55 PM shamim007
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 06, 2017 at 06:40 PM

Seen: 94 times

Last Updated: Jan 11, 2017 at 02:45 PM

Copyright 2018 Redgate Software. Privacy Policy