Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Cisco Call manager maintainance

Dear Friends,

I have a MCS-7835 call manager server,with 80GB HDD capacity,in which nearly 60gb space is occupied with call manager soft and lots of log file for last 1yr.Can anone suggest me which files are to be deleted for freeing the HDD space.

Regards,

kumarjeet

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: Cisco Call manager maintainance

Hi Kumarjeet

From http://msdn2.microsoft.com/en-us/library/aa174538(SQL.80).aspx

If log records were never deleted from the transaction log, the logical log would grow until it filled all the available space on the disks holding the physical log files. At some point in time, old log records no longer necessary for recovering or restoring a database must be deleted to make way for new log records. The process of deleting these log records to reduce the size of the logical log is called truncating the log

This said, it is very important to keep a backup of your system at any stage. Hence installing and taking backup with BARS should be your first step.

Truncating of logs would not be deleting any CDR records as such.

3 REPLIES
Cisco Employee

Re: Cisco Call manager maintainance

Hi Kumarjeet

It could be the CDR/ART log files. Try the following commands :

C:\>osql -E

1> use art

2> go

1> backup log art with no_log

2> go

1> dbcc shrinkdatabase (art)

2> go

C:\>osql -E

1> use cdr

2> go

1> backup log cdr with no_log

2> go

1> dbcc shrinkdatabase (cdr)

2> go

New Member

Re: Cisco Call manager maintainance

hi Behram,

Thanks a lot for the solution.But i havent done the process yet which u have suggested ,as i have few more queries,such as I havnt installed the BARS for backup.What would be the consequence if i shrink ithe CDR/CAR file without taking the backup.I am also running a third party call billing software on another server which extrects the Call deatils.

Your valuable suggestion will promt me to go ahead with the process u have suggested.

Thanks and regards,

Kumarjeet Acharya

Cisco Employee

Re: Cisco Call manager maintainance

Hi Kumarjeet

From http://msdn2.microsoft.com/en-us/library/aa174538(SQL.80).aspx

If log records were never deleted from the transaction log, the logical log would grow until it filled all the available space on the disks holding the physical log files. At some point in time, old log records no longer necessary for recovering or restoring a database must be deleted to make way for new log records. The process of deleting these log records to reduce the size of the logical log is called truncating the log

This said, it is very important to keep a backup of your system at any stage. Hence installing and taking backup with BARS should be your first step.

Truncating of logs would not be deleting any CDR records as such.

186
Views
0
Helpful
3
Replies
CreatePlease login to create content