[cisco-voip] CDR_log Transaction Files

[Ryan Ratliff]

First of all set up BARS or STI backup as it will automatically clear 
out the transaction logs each night for any database you choose to 
backup.

If the transaction log is already empty, you can recover space by 
right-clicking on the CDR database and choosing "Shrink Database".
If you need to clear out the transaction log before shrinking do the 
following from a command prompt:

osql -E
use <database>
go
backup log <database> with no_log
go
dbcc shrinkdatabase <database>
go

where <database> is the name of the database you need to clear out and 
shrink.  In your case it will be CDR.

-Ryan
On Jun 24, 2005, at 9:36 AM, George Dormishev wrote:

Hi all,
	How can i clear the transactional file of the CDR when it grows large? 
Or
make a now one?

Thanks in advice!

/George
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip