Post reply

Two way transactional replication.

  • July 2, 2008 at 4:46 am

    #187782

    I took a full backup of the db to be replicated and restored on server to be configured as subscriber.Then I configured Transactional replication with updatable subscriptions, Immediate updating,push subscription.

    Is it a two-way replication ? If not what else option should be set to make it two way ?

    Also , when i perform a test - insert/update, It reports an error -

    Transactional Replication Triggers are Missing on Subscriber

    Server: Msg 50000, Level 15, State 5, Line 12

    Please advise.

  • July 2, 2008 at 12:23 pm

    #837391

    ansz5 (7/2/2008)

    I took a full backup of the db to be replicated and restored on server to be configured as subscriber.Then I configured Transactional replication with updatable subscriptions, Immediate updating,push subscription.

    Is it a two-way replication ? If not what else option should be set to make it two way ?

    Also , when i perform a test - insert/update, It reports an error -

    Transactional Replication Triggers are Missing on Subscriber

    Server: Msg 50000, Level 15, State 5, Line 12

    Please advise.

    take a look at "peer-to-peer" replication


    * Noel

  • July 3, 2008 at 12:49 am

    #837627

    I am soory , I forgot to mention that I am working on SQL Server 2000.

    so .. no option for 'Peer to Peer Replication'

    Please advise.

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

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