Enabling and Disabling of Service Broker property of a database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sajal Kumar - 06 Dec 2006 16:25 GMT

Hi,
My tests indicate that once i turn broker_enabled property off, backup the
database, restore, then set the broker_enabled property on, backup the
database, restore, it still remains turned off. Is this the expected behavior
or that i am lost here.

Sincerely,
Sajal.

Reply to this Message

Roger Wolter[MSFT] - 06 Dec 2006 20:29 GMT

Restore uses the broker_enabled property to prevent chaos if two different
copies of the same messages are created by restoring the database to a
second location. If you are really restoring the original database, you
should specify the ENABLE_BROKER option in the RESTORE command so that the
broker will be enables as soon as the database recovery is complete.

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

> Hi,
> My tests indicate that once i turn broker_enabled property off, backup the
[quoted text clipped - 5 lines]
> Sincerely,
> Sajal.

Reply to this Message