SQLTeam.com | Weblogs | Forums

Migrating a Service Broker (2005) to and SQL 2014 AG Environment

sql2014

#1

We are migrating from a 2005 to a 2014 with always on Availability group

there is a Service Broker on the database. We migrated it over, there were no endpoints created for it so we enabled the Service Broker, Added endpoints and nothing.

Transmission Queue is blank
There are a ton (190Mil) of DI status Conversations endpoints because the code appears to never END CONVERSTATION I sent that over to the AppDevs to fix, I ran code to remove them in my dev\migration environment.

I check the Queue Monitors and they return Queue state = Not available.