[cisco-voip] CDR_log.LDF huge size

[Ryan Ratliff]

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