<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=idOWAReplyText236 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>I have just shrink the database with the
previous commands and it has reduced the size of the file from 31Gb to 500Kb
without any problem! </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>We have noticed that the CCM's CPU in the
server has increased to about 50% usage during 4 to 5 minutes (RTM is great!)
but it hasn't produced any effect in the call handling or any other
application...</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Thanks to everybody for the
help,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Ruben</FONT></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:40<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>Yup, that looks like it's directly taken from Wes' old bug
:)<BR><BR>Note that the db shrink will take a while to execute on a
32Gb <BR>transaction log.<BR><BR>-Ryan<BR><BR>On Jan 31, 2007, at 9:36 AM,
Ruben Montes ((Europe)) wrote:<BR><BR>Hi,<BR><BR>if I execute the following
commands will I reduce the size of this file?<BR><BR>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<BR><BR>Thanks,<BR><BR>Ruben<BR><BR>De: Ryan Ratliff [<A
href="mailto:rratliff@cisco.com">mailto:rratliff@cisco.com</A>]<BR>Enviado el:
mié 31/01/2007 15:32<BR>Para: Ruben Montes (Europe)<BR>CC: Joe Pollere (US);
cisco-voip@puck.nether.net<BR>Asunto: Re: [cisco-voip] CDR_log.LDF huge
size<BR><BR>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><BR></FONT></P></DIV>
</BODY>
</HTML>