CUCM Upgrade: Purging CDRs

Posted: January 26, 2009 in CCIE VOICE-LAB
Tags: ,

Cisco recommends purging CCM 4x CDR database before running the DMA tool to migrate CCM 4x to 5x/6x.You may use either method shown below to reduce the CCM 4 CDR database.

Method#1 (My favourite)

Shrink the database via the SQL Enterprise Manager.

Note: This is done on the Publisher.

  1. Select Start > Programs > MS SQL Server > Enterprise manager.
  2. Choose the Publisher server.
  3. You can either go to the ART database or CDR database, based on which file is large.
  4. Right-click the database.
  5. Select All Tasks > Shrink database and click Files.
  6. Select the database file CDR and CDR_log on the new window.
  7. Shrink each of them.This process takes some time.If the file is still large or SQL is not able to shrink the transactional file, use Solution 3.

Method#2:

For SQL 2000 (Cisco CallManager 3.3 and 4.0), complete these steps to reduce the size of the CDR_log.LDF. This is located at C:\Program Files\Microsoft SQL Server\MSSQL\Data.

Use these commands at the command prompt:

ART
C:\>osql -E
1>use art
2>go

1>backup log art with no_log
2>go

1>dbcc shrinkdatabase (art)
2>go

CDR
C:\>osql -E
1>use cdr
2>go

1>backup log cdr with no_log
2>go

1>dbcc shrinkdatabase (cdr)
2>go

Cheers, Push
Advertisements

Leave a Reply , I will reply ASAP

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s