Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Enable Broker Service Expand / Collapse
Author
Message
Posted Monday, October 25, 2010 10:44 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, September 21, 2011 4:03 AM
Points: 713, Visits: 100
Comments posted to this topic are about the item Enable Broker Service

--------------------------------------------------------------------------------
Mayank Parmar
Software Engineer

Clarion Technologies
SEI CMMI Level 3 Company

8th Floor, 803, GNFC info Tower,
SG Highway, Ahmedabad - 380 054,
Gujarat, India.
www.clariontechnologies.co.in

Email: mayank.parmar@clariontechnologies.co.in
MSN : mayank.parmar@clariontechnologies.co.in
Mobile: +91 9727748789
--------------------------------------------------------------------------------
Post #1010524
Posted Monday, October 25, 2010 11:13 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
Nice question on something most people probably don't know anything about. Thanks!
Post #1010530
Posted Monday, October 25, 2010 11:55 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:29 PM
Points: 1,012, Visits: 1,001
Nice question, thanks.

Here is also a discussion on this topic: http://social.msdn.microsoft.com/Forums/en-US/sqlservicebroker/thread/eca47504-9a8c-4c0f-a4a4-3a56fb5a012b

Post #1010541
Posted Tuesday, October 26, 2010 12:33 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 8:39 AM
Points: 1,115, Visits: 454
Another Good question, one which I needed to read up about as we do not use the Service Broker where I work.
Post #1010552
Posted Tuesday, October 26, 2010 12:45 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 20, 2014 5:13 AM
Points: 1,131, Visits: 1,394
Good question with nice/tricky options.

I was thinking for following options are the candidates:
ALTER DATABASE db2 SET DISABLE_BROKER ; ALTER DATABASE db2 SET ENABLE_BROKER;
ALTER DATABASE db2 SET NEW_BROKER

But after reading some links got the right answer - NEW_BROKER.


Thanks
Post #1010554
Posted Tuesday, October 26, 2010 1:32 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:49 AM
Points: 1,451, Visits: 1,855
Great question!
The Enable broker and new broker were obvious candidates, but it took some Books On line reading to get to NEW_BROKER.
Got to learn something new on Service Broker today. Thank-you!


Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1010571
Posted Tuesday, October 26, 2010 1:40 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 13,570, Visits: 11,383
Nice question about an unknown subject.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1010575
Posted Tuesday, October 26, 2010 2:34 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, February 7, 2013 5:12 AM
Points: 509, Visits: 182
I'm sorry, but I do not believe that the question was phrased very well. To 'enable' Service Broker for the database, you use the ENABLE_BROKER option, as stated in the msdn article you posted [url=http://msdn.microsoft.com/en-us/library/bb522682(v=SQL.100).aspx][/url]

ENABLE_BROKER
Specifies that Service Broker is enabled for the specified database. Message delivery is started, and the is_broker_enabled flag is set to true in the sys.databases catalog view. The database retains the existing Service Broker identifier.


To reset/assign a new Service Broker Id for a restored database, you would use the NEW_BROKER option.

NEW_BROKER
Specifies that the database should receive a new broker identifier. Because the database is considered to be a new service broker, all existing conversations in the database are immediately removed without producing end dialog messages. Any route that references the old Service Broker identifier must be re-created with the new identifier.


Phil

Although all answers are replies, not all replies are answers.
Blog: http://philjax.wordpress.com
Post #1010594
Posted Tuesday, October 26, 2010 2:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 2:56 AM
Points: 2,842, Visits: 3,876
<nitpick mode="on" />

I would issue a simple
ALTER DATABASE db2 SET ENABLE_BROKER

, since noone said that the broker service had already been enabled in db1
<nitpick mode="off" />

Ok, common sense told me that I should assume the service had already been enabled in db1 as well, so I chose the right answer.


Best Regards,
Chris Büttner
Post #1010597
Posted Tuesday, October 26, 2010 2:41 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, September 21, 2011 4:03 AM
Points: 713, Visits: 100
Yes Phil,

Normally to enable the Broker Service, you need to simply use : "ENABLE_BROKER"

But when you restore the back up of database db1 to database db2, and after that if you want to enable broker service on database db2, then what to do? - That was my question.

Regards,
Mayank


--------------------------------------------------------------------------------
Mayank Parmar
Software Engineer

Clarion Technologies
SEI CMMI Level 3 Company

8th Floor, 803, GNFC info Tower,
SG Highway, Ahmedabad - 380 054,
Gujarat, India.
www.clariontechnologies.co.in

Email: mayank.parmar@clariontechnologies.co.in
MSN : mayank.parmar@clariontechnologies.co.in
Mobile: +91 9727748789
--------------------------------------------------------------------------------
Post #1010601
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse