none
SQl Merge Publication

    Question

  • Hi

    I have a merge replication between SQL Server 2005 (Publisher), and multiple SQl Compact Database (Subscriber),which was working fine, suddenly it stopped working and throwing the error message the below error messages

    1) The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active.

    2) The merge process could not enumerate changes at the 'Publisher'. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write

    So I just restarted the SQL Server Agents, and dropped the Merge replication using the below commands

    sp_removedbreplication 'dbname' EXEC sp_dboption 'dbname','published’, false

    Then I started to create the Merge replication using the new publication wizard with the merge publication type and added the 2 articles to the publication and clicked finish

    It is throwing the error

    Invalid object name 'sysarticles'. (find down the  picture inserted for more detail.

    So I unable to the create the merge replication.

    Anyone can help me out to figure out why this error message occurs?




    Srikanth[096]

    Monday, September 16, 2013 1:31 PM

Answers

All replies

  • You should have just run the merge agent again. It likely would have completed the sync the second time around.

    Now to fix your problem - you have destroyed your subscription/publication. You will unfortunately need to recreate it.

    I would first off try to issue this in your publication database

    sp_replicationdboption 'DatabaseName',publish, true

    sp_replicationdboption 'DatabaseName','Merge publish', true

    Then close management studio open it up again and try to recreate your publication.


    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

    • Marked as answer by Srikanth[096] Tuesday, September 17, 2013 5:40 AM
    Monday, September 16, 2013 2:25 PM
  • Yeah now  i am able to create the merge publication with out issue after the executing below scripts

    sp_replicationdboption 'DatabaseName',publish, true

    sp_replicationdboption 'DatabaseName','Merge publish', true

    Thanks for your Prompt Reply.

    Srikanth[096]

    Tuesday, September 17, 2013 5:44 AM