Core Issue
There are some general procedures that can be completed in order to recover hard drive space in a Cisco CallManager server, such as to shrink CDR and ART (CAR) databases or erase/disable Cisco CallManager traces.
Resolution
In order to resolve this issue, complete these steps in order to shrink the CDR Dabatase.
- From the Cisco CallManager server, open a command prompt and type:
C:\>osql -E
1> use cdr
2> go
1> backup log cdr with no_log
2> go
1> dbcc shrinkdatabase (cdr)
2> go
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
------ ------ ----------- ----------- ----------- --------------
13 1 368 96 360 360
13 2 96 63 96 56
(2 rows affected)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
1> create table Test (test int DEFAULT NULL NULL)
2> go
1> insert into Test (test) VALUES (1)
2> go
(1 row affected)
1> declare @t integer
2> set @t = 0
3> use cdr
4> while (@t <_ _="_" _100000br="_100000br">5> BEGIN
6> update Test set test=1 where test=1
7> select @t = @t + 1
8> if ((@t % 500) = 0)
9> BEGIN
10> select @t
11> END
12> END
13> go
// you will see a lot of "(1 row affected)"
(1 row affected)
1> drop table test
2> go
1> checkpoint
2> go
1> dbcc shrinkdatabase (cdr)
2> go
DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages
------ ------ ----------- ----------- ----------- --------------
13 1 368 96 360 360
13 2 96 63 96 56
- When this procedure finishes, a message similar to this appears:
(1 row affected) DBCC execution completed. If DBCC printed error messages, contact your system administrator.
That procedure is for CDR, but you can shrink the ART database in the same way.
- Change cdr for art in the previous procedure. This restores hard drive space.
- Also, if it is not necessary to capture Cisco CallManager trace files, disable trace output files.
- Choose CCM Admin > Application > Serviceability >Trace > Configuration > select your server > select 'Cisco CallManager' > Uncheck the button for
'Enable File Trace Log'.
Also, check if there are unnecessary trace files at c:\ProgramFiles\Cisco\Trace\CCM\*.txt.
Refer to Shrink the CDR/CAR Database Size for more information.
Note: The information applies to both Cisco CallManager 3.x and Cisco CallManager 4.0.