<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Thanks for your sharing Lelio.</FONT></DIV>
<DIV><FONT face=Arial size=2>So sad to hear no redundancy</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>regards,</FONT></DIV>
<DIV><FONT face=Arial size=2>Robin</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=lelio@uoguelph.ca href="mailto:lelio@uoguelph.ca">Lelio Fulgenzi</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=ciscozest@gmail.com
href="mailto:ciscozest@gmail.com">Robin H</A> ; <A
title=cisco-voip@puck.nether.net
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, December 09, 2005 9:55
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [cisco-voip] Automatic Sql
DB copied from Subscriber to Publisher</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>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.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>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. </FONT></DIV>
<DIV> </DIV>
<DIV>--------------------------------------------------------------------------------<BR>Lelio
Fulgenzi, B.A.<BR>Network Analyst (CCS) * University of Guelph * Guelph,
Ontario N1G 2W1<BR>(519) 824-4120 x56354 (519) 767-1060 FAX
(JNHN)<BR>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<BR>"I had a coffee and Coke at lunch today...and now, I've got more jitter
than an<BR>IP phone on a long haul 10base2
connection"
LFJ</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=ciscozest@gmail.com href="mailto:ciscozest@gmail.com">Robin H</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=cisco-voip@puck.nether.net
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, December 09, 2005 7:42
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [cisco-voip] Automatic Sql DB
copied from Subscriber to Publisher</DIV>
<DIV><BR></DIV>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.
<P>
<HR>
<P></P>_______________________________________________<BR>cisco-voip mailing
list<BR>cisco-voip@puck.nether.net<BR>https://puck.nether.net/mailman/listinfo/cisco-voip<BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>