Post reply

adding a new suscriber in transactional replication

  • March 28, 2007 at 12:29 pm

    #176898

    hi,

    I have to add a new subscriber to an existing transactional replication running on SP4 and SQL Server 2000. Does anyone know how to go about it?

    In the present senario Server 'A' (publisher) is replicated (Transaction replication) to Server 'B'(subscriber) and now Server 'A' has to be replicated (transaction replication) to Server 'B' and Server 'C'(subscriber) (which is the new Server).

  • March 29, 2007 at 6:13 am

    #697621

    If you are going to replicate same articles to Server 'C' which you are replicating now to Server 'B' then Right click on publications & click on  "Push New Subscriber" or you have to create new publication if tables\articles will be different from Server'B'. I hope this will help

  • March 29, 2007 at 9:36 am

    #697670

    thank you very much

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

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