(I hope I haven't broken any rules - I posted this in high availability but on second thoughts decided it would be better here - can't see how to move it :doze
I have somehow (having never even heard of service broker before I started!) created what is now a very stable, robust service broker setup to record website audit data (what was clicked, what appeared - that sort of thing) for our live website.
Right now, the source and target queues are in the same database, living on the live cluster that serves the website.
The audit data is growing fast, so what I need to do is leave the enqueue operation and the source queue on the live cluster where it can benefit from all the safety and security of the live environment, but move the dequeue operation and the storage part of the database to a massive new server we have commissioned just for storing the data (the new server is huge, but less well protected. The idea being that if it goes offline for maintenance service broker will look after the messages until the target is ready to receive them once more).
I could take the website down, copy the database over, create or recreate all necessary SSB objects, swap certificates etc. and get it running before restarting the website, but I am worried about how long the site will be unavailable, and about delays if the deployment doesn't go smoothly (again the downtime would be a worry), so I wondered if I could stop a queue - the source queue presumably - and allow audit messages to build up while I did all the moving and recreating behind the scenes without affecting the website at all, then once it was all sorted, re-enable the source queue (with its new routing and binding, new certificate, new dedicated user etc.) and it would resume processing as if nothing had happened?
Would that work? Is there anything I would have to be aware of or do specifically to ensure the stacked up messages would process successfully when I switch the queue back on? Or would the fact hat the messages were enqueued with a certain routing mean that they would fail under the new arrangement as everything had changed?
Thanks for your help!