Post reply

Cyclical forwarding detected for event 18204 (SQL Server 2005)

  • May 8, 2008 at 9:26 am

    #186301

    The following error is being generated when the Transaction Log job is executed:

    "[LOG] Cyclical forwarding detected for event 18204: Event source was '[ServerName]' which matches the current forwarding server. The event was not forwarded"

    We recently disabled mirroring in SQL Server 2005. I think this error may be related but I'm really not sure. Any ideas or suggestions would be greatly appreciated.

    AB

  • May 8, 2008 at 9:40 am

    #812504

    Do you mean a transaction log backup job?

    Events can be forwarded to other servers and it appears from the error that you might have circular reference (server 1 forward to server 2 which forwards to server 1). http://msdn.microsoft.com/en-us/library/ms189046.aspx

  • May 8, 2008 at 9:52 am

    #812513

    Steve,

    Thanks for your input. I was referring to a Transaction Log Job. I'll take a look at the msdn url you suggested and let you know if this resolves my issue. Thanks again.

    AB

  • May 8, 2008 at 1:42 pm

    #812659

    Steve,

    Thanks for your help. I deselected the "Forward events to a different server" checkbox and the job executed without errors.

    AB

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply