<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7650.5">
<TITLE>Re: [cisco-voip] CDR_log.LDF huge size</TITLE>
</HEAD>
<BODY>
<DIV id=idOWAReplyText21080 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Hi,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>if I execute the following commands will I
reduce the size of this file?</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr>osql -E<BR>1> use cdr<BR>2> go<BR>1> backup log cdr with
no_log<BR>2> go<BR>1> dbcc shrinkdatabase(cdr)<BR>2>
go<BR>1>exit</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>Thanks,</DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr>Ruben</DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>De:</B> Ryan Ratliff
[mailto:rratliff@cisco.com]<BR><B>Enviado el:</B> mié 31/01/2007
15:32<BR><B>Para:</B> Ruben Montes (Europe)<BR><B>CC:</B> Joe Pollere (US);
cisco-voip@puck.nether.net<BR><B>Asunto:</B> Re: [cisco-voip] CDR_log.LDF huge
size<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>It may take a while but you can still enable BARS to back up
your <BR>CDRs. If your transaction log is filling up that
quickly then it <BR>sounds like you have a pretty hefty call volume and you
have hit he <BR>max amount of CDR records so Aupair is having to delete a
lot of them <BR>to bring you back down. The max records by
default is 1.5 million <BR>and is set via a service parameter for Database
Layer Monitor (aka <BR>Aupair).<BR><BR>There is a SQL job that will
truncate the logs as well but it only <BR>triggers if the c: drive gets
below 500Mb free space.<BR><BR>-Ryan<BR><BR>On Jan 31, 2007, at 8:54 AM, Ruben
Montes ((Europe)) wrote:<BR><BR>Hi,<BR><BR>BARS is actually not backing up the
CDR. Can I still configure it now <BR>or it's too late due to the size of
the file?<BR><BR>Thanks,<BR><BR>Ruben<BR><BR>De: Joe Pollere (US) [<A
href="mailto:Joe.Pollere@us.didata.com">mailto:Joe.Pollere@us.didata.com</A>]<BR>Enviado
el: mié 31/01/2007 13:59<BR>Para: Ruben Montes (Europe);
cisco-voip@puck.nether.net<BR>Asunto: RE: [cisco-voip] CDR_log.LDF huge
size<BR><BR>Ruben,<BR><BR><BR>You need to truncate the log file. There is a sql
command to do it. <BR>Alternatively if you back up with BARS select CDR and
BARS will <BR>truncate for you as part of the backup
process.<BR><BR><BR>Joe<BR><BR><BR>From: cisco-voip-bounces@puck.nether.net [<A
href="mailto:cisco-voip-">mailto:cisco-voip-</A><BR>bounces@puck.nether.net] On
Behalf Of Ruben Montes (Europe)<BR>Sent: Wednesday, January 31, 2007 4:54
AM<BR>To: cisco-voip@puck.nether.net<BR>Subject: [cisco-voip] CDR_log.LDF huge
size<BR><BR><BR>Hi,<BR><BR>I have noticed that my CDR_log.LDF file, that is
located in C:<BR>\Program Files\Microsoft SQL Server\MSSQL\Data has a size of
32GB and <BR>is growing 5GB per week. I suppose there should be a bug
behind, but <BR>the for the moment I want to stop this growing...<BR><BR>Do
you know if it is enough with putting the service parameter CDR <BR>Enabled
flag to false to stop collecting CDR information? Later on <BR>I'll see how
we will purge this because I assume it will be a CPU <BR>intensive
process...<BR><BR>I have a TAC case opened, but for the moment the engineer it
is not <BR>helping me very
much...<BR><BR>Regards,<BR><BR>Ruben<BR><BR>_______________________________________________<BR>cisco-voip
mailing list<BR>cisco-voip@puck.nether.net<BR><A
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</A><BR></FONT></P></DIV>
</BODY>
</HTML>