Stopping and Restarting Replication

  • 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.

  • 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.

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

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

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