Query notifications (service broker) and mirroring

Hi,
I'm trying to turn on service broker so we can use query notifications in a
mirrored database. However I get the following when I try to run ALTER
DATABASE <db>
SET ENABLE_BROKER:
Msg 9778, Level 16, State 1, Line 2
Cannot create a new Service Broker in a mirrored database "testDB".
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
Can you use query notifications with a mirrored db?
Thanks in advance.
You must enable broker before the mirroring session is enabled. You should
first check if the broker is enabled in the first place
(sys.databases.is_broker_enabled). If is not, then you must stop the
mirroring session, enable the broker and re-establsih the mirroring session
from scratch.
HTH,
~ Remus
"sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
news:30FC2CF3-B85C-4B40-A4FD-D028F19CD6D8@.microsoft.com...
> Hi,
> I'm trying to turn on service broker so we can use query notifications in
> a
> mirrored database. However I get the following when I try to run ALTER
> DATABASE <db>
> SET ENABLE_BROKER:
> Msg 9778, Level 16, State 1, Line 2
> Cannot create a new Service Broker in a mirrored database "testDB".
> Msg 5069, Level 16, State 1, Line 2
> ALTER DATABASE statement failed.
>
> Can you use query notifications with a mirrored db?
> Thanks in advance.
|||Remus ,
Thanks for your reply. Will the service broker failover along with the
database?
"Remus Rusanu [MSFT]" wrote:

> You must enable broker before the mirroring session is enabled. You should
> first check if the broker is enabled in the first place
> (sys.databases.is_broker_enabled). If is not, then you must stop the
> mirroring session, enable the broker and re-establsih the mirroring session
> from scratch.
> HTH,
> ~ Remus
> "sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
> news:30FC2CF3-B85C-4B40-A4FD-D028F19CD6D8@.microsoft.com...
>
>
|||Yes
"sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
news:4B43EA5F-3340-41DD-9407-A0ED711F2726@.microsoft.com...[vbcol=seagreen]
> Remus ,
> Thanks for your reply. Will the service broker failover along with the
> database?
>
> "Remus Rusanu [MSFT]" wrote: