[cisco-voip] Unity 4.X - sql replication

[Thorsten.Mayr at barclayscapital.com]

Guys,

Unity problem where SQL replication was (yet again broken) but had to
failover to run on standby. The question or rather quest is (how) to get
the changes back on the primary with the least amount of downtime.

HTTS view is to do a clean reinstall of the primary - DIRT backup of the
standby to get the latest data and restore back onto primary...
Fix up lic etc.. And rerun failover wizard on both... job done... - sure
is a clean way but will take at least good 6hours not to mention the
downtime, or the amount of work involved... 

I was hoping to find a dirty hack.. So here are my thoughts...:

Just started looking at the DB structure... and I think I could safely
"manually update" the subscriber table as we didn't add any new
subscribers onto this cluster (for that reason).
The main changes are pwd's & greetings... could also just copy and paste
the pwd hashes.... To make sure I capture all changes might as well
copy/update/transfer the whole lot as I couldn't find any references
that might screw it up (same switch id etc..)
Also will have to copy the greetings etc... manually (should be an easy
one as well).


The trickier part I am looking at are the call handlers...  there quite
a few references in there which seem to be local to the box...
And to make things worse we had to create a few new ones... (might be
easier to recreate them manually)

Was wondering if anybody has been in that situation before or similar
(am thinking of running the failover wizard and change the roles that
way - then fix up the global entries manually as well as lic) - will
give that a shot in the lab... SQL is already broken anyway
Or maybe manually set up a replication based on timestamps... (if there
is enough) and once all is replicated, failover. Delete the replication
and run failover wizard again to get it back to Cisco supported
standards.

Thinking out loud - messing the replication will probably just take up
as much time as doing a clean install...


Anyway would welcome anybodies view / hints / do's and don't do's
general 2 cents on this

Thanks in advance
T
_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing.  Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP.  This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________