Update in Merge Replication

  • I configured a merge replication with seven subscriber. The database has 30 tables. I had to add 2 tables to the database and I generated the new snapshot, the new snapshot was generated ok, but I can´t update any table in the database, because appears a message that you can see in the error.JPG

    Error Message: Table dbo.Usuarios into which you are trying to insert, update or delete is currently being

    upgraded or initialized for merge replication. On the publisher data modifications are disallowed until the upgrade

    completes ad snapshot has succesfully run. On subscriber data modifications are disallowed until the upgrade completes

    or the initial snapshot has been succesfully applied and it has syncronized with the publisher.

    The snapshot was generated 1 hour ago and the database is not big, I think thatI I will not be able to update the tables any more. What can I do?

  • Please refer to this thread or the MS thread linked in the thread. http://www.sqlservercentral.com/Forums/Topic332967-146-1.aspx#bm333212

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply