Post reply

I need to move distributer DB, but how?

  • May 16, 2008 at 4:35 am

    #187756

    We currently have merge replication set up between 4 servers. The distribution DB is set up locally on one of the servers, which pushes all updates to the other servers.

    The server which has the distributer DB, is having a few performance problems which we think is down to the distributer DB. Therefore we want to move it to a fifth server, but not sure how?

  • May 19, 2008 at 9:42 am

    #817276

    The only supported way is to breakdown repl, setup dist on the new box, and then re-create all your publ and subs.

    There might be a way through backup/restore of the dist box to the new server, but you'll have to go in and modify all the system tables on the pub/dist/sub to all point to the new dist box. I doubt that'll be supported, but I see no reason why it wouldn't be possible. But you'll still have to stop repl to make that happen.

    My advice though is to delete the entire scenario and start again with dist on the new box.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

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

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