April 17, 2017 at 9:02 am
Hi,
I get the below error in the errorlog almost daily after the the tllog backup id done that too in the evening. The server has the reporting databases hosted.
The Service Broker endpoint is in disabled or stopped state.
Unable to find any relation with this error.
Against the reporting databases the broker is enabled.
Kindly suggest a way to start looking into this alert to fix this.
Thanks.
April 17, 2017 at 6:19 pm
SQL-DBA-01 - Monday, April 17, 2017 9:02 AMHi,
I get the below error in the errorlog almost daily after the the tllog backup id done that too in the evening. The server has the reporting databases hosted.
The Service Broker endpoint is in disabled or stopped state.Unable to find any relation with this error.
Against the reporting databases the broker is enabled.
Kindly suggest a way to start looking into this alert to fix this.
Are you using AOAG? There is a bug up on connect related to that - not sure if it's really a bug or just an obnoxious behavior. Happens when the Always on availability group listener is changed, created . It's an informational message but a bit irritating:
AlwaysOn:: The Service Broker endpoint is in disabled or stopped state
Sue
April 17, 2017 at 8:31 pm
Any way to suppress the alert? Can we use any trace flag to suppress it?
Thanks.
April 18, 2017 at 8:07 am
SQL-DBA-01 - Monday, April 17, 2017 8:31 PMAny way to suppress the alert? Can we use any trace flag to suppress it?
Unfortunately no. I would guess that's likely why the connect item is still active - there isn't a way to stop the logging of message which is meant to be an informational message.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply