[cisco-voip] CDR_log.LDF huge size

[Mike Lay (milay)]

There are a couple of things here. First you need to ensure the records
are being pruned, have you changed the max numbers of records allowed
from the default of 1.2million, DBL service parameter? Is CAR installed
& configured to remove CDR & ART records after a set number of days? If
the answer to all of the above is yes you may have an issues with the
transaction log not being cleared. You cab check the transaction in SQL
Enterprise Manager by changing the view to Status View, it will be in
the left window graphically. Keep in mind that once the total allocated
space is expanded it will never shrink in size by it's self.  Also
regular backups of the Pub will truncate & purge automatically.
 
To purge the transaction log & shrink the DB manually in SQL query
analyzer, may or may not need the "'s depending on the SQL version:
 
Here is how we truncated the transaction log for CDR:

1) ISQLW
2) select the CDR DB
3) execute "dump tran "CDR" with no_log"
Had to truncate the ART transaction log through ISQLW:

1) ISQLW
2) select the ART DB
3) execute "dump tran "ART" with no_log"
Mike
 
 
________________________________

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 3: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/37ea908a/attachment-0001.html