Post reply

Peer to Peer Transactional Replication (Error 515)

  • January 24, 2013 at 3:42 pm

    #269470

    Peer to Peer Transactional Replication

    "Microsoft.SqlServer.ConnectionInfo

    Cannot insert the value NULL into column 'article_id'.table'distribution.dbo.MSrepl_commands'; the column does not allow NULLLS. INSERT fails. The subscription does not exist. The subscription could not be found. (Microsoft SQL Server, Error 515)

    I am getting this error after addin a node in Peer to peer topology and setting it to 'FINISH'

    Any Idea about this error. ?

    Thanks in advance

  • January 24, 2013 at 4:12 pm

    #1580755

    Got the solution.

    Take backup and restore on second node only after creating publication in first node. Actually i restored the database before creating the publication on first node.

    http://sqlism.blogspot.com/2013/01/peer-to-peer-transactional-replication.html

    Thanks everyone for looking into this.

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

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