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...
> > 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.
>
>|||Yes
"sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
news:4B43EA5F-3340-41DD-9407-A0ED711F2726@.microsoft.com...
> 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...
>> > 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.
>>