Recently I applied service pack 2 in one of the cluster environment which is SQL server 2008 R2. After applying SP2, few information logs was generating on 2008 SQL Servers which was related to SQL Agent service, these logs were filling up in system application event logs in all the SQL Server nodes.
I was getting below information message in application log:
Message
The
description for Event ID '1073741877' in Source 'SQLAgent$Name' cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display the message, or you may not have permission to
access them. The following information is part of the event:'[sqagtres]
LooksAlive request.
'
Message
The
description for Event ID '1073741877' in Source 'SQLAgent$Name' cannot be
found. The local computer may not have the necessary registry information
or message DLL files to display the message, or you may not have permission to
access them. The following information is part of the event:'[sqagtres]
CheckServiceAlive: returning TRUE (success).
As per Microsoft articles:
The issue occurs because of a code defect in the Sqagtres.dll SQL Server Agent resource file. The information that is mentioned in the "Symptoms" section should not be logged.
The resolution for this bug has been fixed in Cumulative update 3. So if anyone is getting this informational message in application log, apply Cumulative update 3 (http://support.microsoft.com/kb/2754552).
For more information you can visit to Microsoft link:
No comments:
Post a Comment