Post reply

Subscriber DB movement from one server to another

  • April 23, 2015 at 6:09 am

    #398365

    Hi,

    I have transactional replication setup from server A to Server B. I wanted to move the subscriber from B to C.

    What could be the best approach.

    1. Backup the DB from Server B and restore on Server C. set the replication between A & C.

    2. setup the transaction replication between A & C along between A & B. Test A& C working fine and then remove B.

    If I am going with approach 2 , I have to replicate data approx. 70 GB so If I ran both the replication on Server A that will stress as 140 GB of data moving out. How do I control this large movement ? Can the replication be manual synch?

    Please guide me

    Minaz

    "More Green More Oxygen !! Plant a tree today"

  • April 24, 2015 at 6:59 am

    #1793246

    Hi All,

    Please provide me your input for both the scenario.

    "More Green More Oxygen !! Plant a tree today"

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

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