Question

Consistent error occuring in SQL Server 2005

SQL Server 2005, Windows Server 2003, SQL error messages

I have five servers in my network. On one member server, I have SQL 2005 Standard ver.9.00.1399.00 running on MS Server 2003 R2 SP2. In my event log on this server, I am receiving an error every couple minutes. They show up in the SQL error log as well as the event viewer. The error is:

Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 319
Date: 6/18/2008
Time: 12:00:30 AM
User: N/A
Computer: AGEDATASERV03
Description:
Cyclical forwarding detected for event 3197: Event source was 'AGEDATASERV03' which matches the current forwarding server. The event was not forwarded.

Is AGEDATASERV03 the name of the machine which has these errors? If it is this is because you have setup message forwarding from this server to it self, or you are forwarding the messages to another server, and that server is forwarding the messages back.

Disable the message forwarding on one or both of the machines and the error should go away.