Create New SQL Publication for CCM0300

Unanswered Question
Aug 24th, 2007

Looks like someone was kind enough to delete the SQL Publication for the CCM0300 database. Now, the subscribers are not replicating with the Publisher.

I know how to re-establish a broken CallManager Cluster SQL Subscription, however, I have never had to re-create the actual Publication on CCM0300.

Is there a document on how to do this? I know the Publication is a Transactional Publication but there are some other parameters that I am unsure of.

Do we publish the Stored Procedures or just the Tables? What about Article Issues?


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
mchandak Fri, 08/24/2007 - 11:03

There is a stored procedure available, but I've never used it. If you are comfortable with SQL, then you can use the stored procedure available at C:\Program Files\Cisco\Bin\PublishCCM0300.sql

Also, please note that this is not TAC Supported.

dmckelvey-eds Fri, 08/24/2007 - 12:58

Thanks for the info. It is always interesting that Cisco has a tool to fix something but it is not supported.

Why have the stored procedure in the first place?

mchandak Fri, 08/24/2007 - 13:00

AFAIK, this is used during the install and therefore this is there

Jason Aarons Sat, 08/25/2007 - 18:17

For CallManager 4.x contact TAC for dblhelper.exe, it has buttons for Publish and re-sycn subscribers -jason


This Discussion