This message could not be delivered because it is duplicate

When I send message from Server1 to Server2,I found the error "This message could not be delivered because it is duplicate" in SQLProfiler on Target, why message can be duplicate ? who can help me?

My environment is :

Instance1 on Server1,Instance2 and Instance3 on Server2,Instance1 and Instance2 is a sqlserver2005 cluster,message is sent from Instance1 to Instance3.

[387 byte] By [Ant19768341] at [2008-1-13]

«« .NET Framework 2.0 Beta 2 setup FAILED!!!
»» Marshaling 2D Arrays C#->Unmanaged

# 1

That means that the source is resending the message because it didn't receive the acknowledgement from the target. The second time the target gets the message it looks in the conversation endpoint and finds it already has that message. The most common cause for that is the route from the target machine back to the initiator machine is missing or wrong. A firewall on the initiator can also block the returning acknowlegements.

Roger_MS at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Service Broker...

# 2

Thx,it is really helpful for my problem.

BTW,Because I have encountered many problem when I built up service broker. where can I find all error detail of service broker ?

Ant19768341 at 2007-9-9 >

# 3

AFAIK, there is no real good source for error info. Try Roger's book, there may be some info there. Whet problems are you encountering? BTW, some of your best friends when trying to solve SSB problems are the sys.transmission_queue queue and the SQL Server Profiler.

nielsb at 2007-9-9 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech