October 3, 2005 at 10:11 am
We have a third party product that installs transactional replication and associated database to be replicated. Currently, in the install process there are no options to change the drive locations for the mdf and ldf files during the install. Is there a way to stop replication without disabling it, so that we can detach and attach the db to change the drive locations of the mdf and ldf files? Thank u.
October 3, 2005 at 10:32 am
You can go into the Replication Monitor in SQL Server Enterprise Manager (it's the picture of the green jagged line icon) and stop it there (I'd stop both the log reader and/or the Publication, depending on if your distributor is on a seperate machine).
You can also go into SQL Server Agent, Jobs and stop the replication related jobs there.
Actually, now that I think of it, the easiest thing to do would probably be to stop the SQL Server Agent, detach and attach your files, then start the Agent back up again.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply