Post reply

Moving Distribution and all related jobs to another server

  • October 21, 2009 at 9:06 pm

    #227288

    I have sql server 2008 as a publisher and sql 2000 as subscriber.

    SQL Server 2008 has distribution database as well. However I want to move the Distribution database and Distribution jobs to sql 2000 server (also subscriber) to shift the overhead to subscriber.

    Is there any way to do this without breaking current replication and preferably online. Since the replication is running persisted tables without snapshots.

    Thanks

    Swarndeep

    http://talksql.blogspot.com

  • October 22, 2009 at 8:04 am

    #1069446

    I am not 100% sure about SQL 2008, but 2005 I thought each publisher could only have 1 distributor(It can either be on the same server, or you can use a distribution server)./

  • October 22, 2009 at 10:49 am

    #1069547

    Thanks for reply. But that I can do while setting up Replication. But in my case Replication is already setup and running well. Anyway, if you find something please let me know.

    Thanks

    Swarndeep

    Swarndeep

    http://talksql.blogspot.com

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

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