Post reply

Stopping and Restarting Replication

  • January 11, 2010 at 2:36 pm

    #138249

    We want to move a database to some different disks. We will accomplish this thru detaching and then reattaching the database. The wrinkle is that this database replicates. What's the best way to turn off replication and then turn it back on in this scenario. The environment is SQL Server 2005.

  • January 11, 2010 at 3:43 pm

    #1102087

    I think that if you disable the jobs so that they don't run during the file move, you should be ok. I haven't used replication in a while, so maybe get another opinion. In situations like this, I often set up a test database, and try out the plan. Nothing like first-hand experience.

  • January 11, 2010 at 6:21 pm

    #1102124

    I agree with homebrew01. First test it and then do it in the production environment.



    My blog

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

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