Post reply

Detach-Attach subscriber database.

  • April 18, 2011 at 2:20 pm

    #235010

    Hello all,

    Can you detach a subscriber (transactional replication) database, move it to a different drive and reattach it without having to re-initialize? Would you need to disable ‘distribution clean-up’ and the Log-reader agent jobs first? I tried in a test environment and it worked. Am I overlooking anything?

    Thanks,

    DK

  • April 18, 2011 at 3:20 pm

    #1313103

    You should be ok. How long do you expect the move to take? I wouldn't disable anything but the distribution agent, not logreader or distribution clean-up. If it was going to be a really long copy then I would disable distribution clean-up but I would also ensure that the retentions were set appropriately - but that would be over days and my guess is that it won't take that long. 🙂

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • April 19, 2011 at 3:19 pm

    #1313659

    Thanks for the reply David,

    It is a bigger file but you are right, it will not take a day to copy.

    Thanks again,

    DK

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

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