[cisco-voip] CDR_log.LDF huge size

[Ruben Montes (Europe)]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20070131/47e668e1/attachment-0001.html