We are getting EventID17052 in one of our production server from last 3 months. SQL Server Agent is restarting on its own. As per threads about same issue I dig into the Jobs and processes running at that time in Server and
I have found one job is causing this issue and Agent crash is happening same time that job is scheduled but not everyday. Server is running with SQL Server 2005 SP2 (Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1) ). Please let me know is there any fix for this error and also let me know SP3 upgrade to SQL Server 2005 will
help for it or not?
I am also providing full error details from event viewer.
The description for Event ID 17052 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
SQLServerAgent Monitor: SQLServerAgent has terminated unexpectedly.
the message resource is present but the message is not found in t
View Complete Post