|
Home > Archive > Voice over IP Cisco > June 2005 > CDR_log Transaction Files
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
CDR_log Transaction Files
|
|
| George Dormishev 2005-06-24, 5:45 pm |
| 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
| |
| Ryan Ratliff 2005-06-24, 5:45 pm |
| 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@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
| |
| Wes Sisk 2005-06-27, 5:45 pm |
| George,
If your transaction logs are growing huge this usually indicates your
backups are failing. 1 of the tasks in teh backup process purges the
transaction logs.
Oterwise
http://www.cisco.com/en/US/customer.../products_tech_
note09186a008049aab0.shtml
/Wes
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net]On Behalf Of George Dormishev
Sent: Friday, June 24, 2005 9:37 AM
To: cisco-voip@puck.nether.net
Subject: [cisco-voip] CDR_log Transaction Files
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@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
|
|
|
|
|