Create New SQL Publication for CCM0300

Unanswered Question
Aug 24th, 2007
User Badges:

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
User Badges:
  • Gold, 750 points or more

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
User Badges:

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
User Badges:
  • Gold, 750 points or more

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

Jason Aarons Sat, 08/25/2007 - 18:17
User Badges:
  • Bronze, 100 points or more

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


This Discussion