[cisco-voip] CDR_log.LDF huge size

[Ruben Montes (Europe)]

Hi,
 
if I execute the following commands will I reduce the size of this file?
 
osql -E
1> use cdr
2> go
1> backup log cdr with no_log
2> go
1> dbcc shrinkdatabase(cdr)
2> go
1>exit
 
Thanks,
 
Ruben

________________________________

De: Ryan Ratliff [mailto:rratliff at cisco.com]
Enviado el: mié 31/01/2007 15:32
Para: Ruben Montes (Europe)
CC: Joe Pollere (US); cisco-voip at puck.nether.net
Asunto: Re: [cisco-voip] CDR_log.LDF huge size



It may take a while but you can still enable BARS to back up your 
CDRs.   If your transaction log is filling up that quickly then it 
sounds like you have a pretty hefty call volume and you have hit he 
max amount of CDR records so Aupair is having to delete a lot of them 
to bring you back down.   The max records by default is 1.5 million 
and is set via a service parameter for Database Layer Monitor (aka 
Aupair).

There is a SQL job that will truncate the logs as well but it only 
triggers if the c: drive gets below 500Mb free space.

-Ryan

On Jan 31, 2007, at 8:54 AM, Ruben Montes ((Europe)) wrote:

Hi,

BARS is actually not backing up the CDR. Can I still configure it now 
or it's too late due to the size of the file?

Thanks,

Ruben

De: Joe Pollere (US) [mailto:Joe.Pollere at us.didata.com]
Enviado el: mié 31/01/2007 13:59
Para: Ruben Montes (Europe); cisco-voip at puck.nether.net
Asunto: RE: [cisco-voip] CDR_log.LDF huge size

Ruben,


You need to truncate the log file. There is a sql command to do it. 
Alternatively if you back up with BARS select CDR and BARS will 
truncate for you as part of the backup process.


Joe


From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-
bounces at puck.nether.net] On Behalf Of Ruben Montes (Europe)
Sent: Wednesday, January 31, 2007 4:54 AM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] CDR_log.LDF huge size


Hi,

I have noticed that my CDR_log.LDF file, that is located in C:
\Program Files\Microsoft SQL Server\MSSQL\Data has a size of 32GB and 
is growing 5GB per week. I suppose there should be a bug behind, but 
the for the moment I want to stop this growing...

Do you know if it is enough with putting the service parameter CDR 
Enabled flag to false to stop collecting CDR information? Later on 
I'll see how we will purge this because I assume it will be a CPU 
intensive process...

I have a TAC case opened, but for the moment the engineer it is not 
helping me very much...

Regards,

Ruben

_______________________________________________
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/20070131/6ebccade/attachment.html