[cisco-voip] Automatic Sql DB copied from Subscriber to Publisher

[Lelio Fulgenzi]

We used to do something like this and take advantage of the database applications on the CallManager servers. However, since they introduced the concept of the shared key between the servers, we were not able to get this working again. No amount of troubleshooting with our local SQL expert was able to help. Eventually we had to drop the idea of using the push/pull subscription and use export/import scripts to replicate the table on the other server. If your database is not that large and doesn't see that many changes, you could probably get away with running the script every hour.

That being said, the TAC does not like you adding your own database on CallManager servers and may infact as you to delete it if they see any problems arise. So were were told. 

--------------------------------------------------------------------------------
Lelio Fulgenzi, B.A.
Network Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
"I had a coffee and Coke at lunch today...and now, I've got more jitter than an
IP phone on a long haul 10base2 connection"                                           LFJ
  ----- Original Message ----- 
  From: Robin H 
  To: cisco-voip at puck.nether.net 
  Sent: Friday, December 09, 2005 7:42 AM
  Subject: [cisco-voip] Automatic Sql DB copied from Subscriber to Publisher


  I need to setup two IVR servers and I plan to store a special-time database (a new table) on CallManager Servers (using Sql). Normally I only create the script to query DB from single server ie: subscriber. But if the subscriber server down, the ivr won't able to give correct prompts. Is there a way I can make that sql db/table to be copied over to another server so that I still have redundancy. Thank you.  


------------------------------------------------------------------------------


  _______________________________________________
  cisco-voip mailing list
  cisco-voip at puck.nether.net
  https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20051209/7ba18949/attachment.html