[cisco-voip] CDR_log.LDF huge size

[Joe Pollere (US)]

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




-----------------------------------------
Disclaimer:

This e-mail communication and any attachments may contain
confidential and privileged information and is for use by the
designated addressee(s) named above only.  If you are not the
intended addressee, you are hereby notified that you have received
this communication in error and that any use or reproduction of
this email or its contents is strictly prohibited and may be
unlawful.  If you have received this communication in error, please
notify us immediately by replying to this message and deleting it
from your computer. Thank you.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20070131/3841cb53/attachment.html