<HTML>
<BODY>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY
style="WORD-WRAP: break-word; khtml-nbsp-mode: space; khtml-line-break: after-white-space">
<DIV dir=ltr align=left><SPAN class=390403416-10022006><FONT face=Arial
color=#0000ff size=2>Most third party CDR reporting applications will move the
CDR records to a reporting server nightly prior to backups. This
allows the CDR database to be purged prior to backup to save space and reduce
time to rebuild. It also saved on CCM CPU cycles when running large
enterprise call usage reports since the reports are run against the reporting
sql database and not callmanager's.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=390403416-10022006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=390403416-10022006><FONT face=Arial
color=#0000ff size=2>Matt</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <B>On Behalf Of </B>Tim
Medley<BR><B>Sent:</B> Friday, February 10, 2006 11:30 AM<BR><B>To:</B>
cisco-voip@puck-nether.net<BR><B>Subject:</B> Re: [cisco-voip]
CDR<BR></FONT><BR></DIV>
<DIV></DIV>Something to consider with increasing the number of CDR's and with
CDR's in general is that the more CDR records you have in the database, the
larger your backup files will be and the longer it takes to perform an upgrade.
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>You can always export the CDR's for archival purposes.</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV>tm</DIV>
<DIV><BR class=khtml-block-placeholder></DIV>
<DIV><BR>
<DIV><SPAN class=Apple-style-span
style="WORD-SPACING: 0px; FONT: 12px Helvetica; TEXT-TRANSFORM: none; COLOR: rgb(0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BORDER-COLLAPSE: separate; border-spacing: 0px 0px; khtml-text-decorations-in-effect: none; apple-text-size-adjust: auto; orphans: 2; widows: 2">
<DIV>Tim Medley</DIV>
<DIV><A href="mailto:medley@mac.com">medley@mac.com</A></DIV>
<DIV><BR class=khtml-block-placeholder></DIV><BR
class=Apple-interchange-newline></SPAN></DIV><BR>
<DIV>
<DIV>On Feb 10, 2006, at 11:20 AM, Philip Walenta wrote:</DIV><BR
class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<DIV dir=ltr align=left><SPAN class=354052016-10022006><FONT face=Arial
color=#0000ff size=2>The default is 2 million records. How many more do
you need?</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> cisco-voip-bounces@puck.nether.net [<A
href="mailto:cisco-voip-bounces@puck.nether.net">mailto:cisco-voip-bounces@puck.nether.net</A>]
<B>On Behalf Of </B>Rubottom, Karl<BR><B>Sent:</B> Friday, February 10, 2006
7:41 AM<BR><B>To:</B> <A
href="mailto:cisco-voip@puck-nether.net">cisco-voip@puck-nether.net</A><BR><B>Subject:</B>
[cisco-voip] CDR<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Is it possible to increase the
maximum database rows in the CDR database?
<O:P></O:P></SPAN></FONT></P></DIV></BLOCKQUOTE>
<DIV style="MARGIN: 0px">_______________________________________________</DIV>
<DIV style="MARGIN: 0px">cisco-voip mailing list</DIV>
<DIV style="MARGIN: 0px"><A
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</A></DIV>
<DIV style="MARGIN: 0px"><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck..nether.net/mailman/listinfo/cisco-voip</A></DIV></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>
<P><hr size=1></P>
<P><STRONG>
Disclaimer:<br>
<br>
This e-mail communication and any attachments may contain<br>
confidential and privileged information and is for use by the<br>
designated addressee(s) named above only. If you are not the<br>
intended addressee, you are hereby notified that you have received<br>
this communication in error and that any use or reproduction of<br>
this email or its contents is strictly prohibited and may be<br>
unlawful. If you have received this communication in error, please<br>
notify us immediately by replying to this message and deleting it<br>
from your computer. Thank you.
</STRONG></P>
</BODY>
</HTML>