Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SuperJB
Starting Member
12 Posts |
 Posted - 2012-04-19 : 06:59:39
|
Hello everyone,Situation:- I have 2 databases (DB_A and DB_B). They have Service Broker configured between them and it's working fine.- A new environment for our application was needed but we didn't have any new "free" servers. So, the solution was to create 2 new databaes (DB_A2 and DB_B2) that were restored from the original DBs on the same instance.- Now, my DB_B2 Service Broker is "speaking" with DB_A instead of DB_A2. Can anyone tell me what I must do to configure the SB correctly?Thanks in advance guys...SuperJB  |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2012-04-30 : 01:27:56
|
| When restoring the dbs be sure to specify NEW_BROKER. This will create new broker GUIDs for use in routing. This may be the source of your issue. |
 |
|
|
|
|
|
Service Broker pointing to wrong DB