[cisco-voip] HUge CDR_log.LDF File

[Wes Sisk]

you must include cdr when perfoming backup.  this allows sql to shrink 
the transaction log. 

it is the same issue as
CSCea55522    art_log.ldf file grows very large, CAR records may stop 
purging

only against the cdr database instead of art database.

take a backup of cdr database.   log file should shrink. if not, there 
are manual steps to shrink it.

/wes

On Monday, April 06, 2009 3:16:08 AM, voip at mrga.ch <voip at mrga.ch> wrote:
> Hello Group
>
> We run a CallManager Cluster 4.2(3).
> Now I discovered that the CDR transaction log file on the publisher 
> became huge (C:\Program Files\Microsoft SQL 
> Server\MSSQL\Data\CDR_log.LDF (32GB)) Right now it is 32 Gb.
>
> How can I shrink this file or at least stop it to grow.
>
> Is this BARS related. I run a backup all night, however I have the 
> CDR option not checked. So the backupfile has a not so big size.
>
> Thanks for help
> Reto
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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/20090406/f894dfb6/attachment.html>