Move distribution physical files SQL 2000

Posted on 2007-07-30
Medium Priority
Last Modified: 2012-08-14

I want to move the physical datafiles associated with the distribution database installed on SQL 2000 when you set up replication.

How can I move these files, I assume it is not a case of detaching and reattaching the DB as this will cause replication to fail

Question by:kinton
  • 2
LVL 12

Expert Comment

ID: 19593683
You can do detach/attach move.  Just stop all replications before and check if no job will start it again (stop Agent). There is no other component holding connection to distribution except replication agents running.

Author Comment

ID: 19593777
What agent do I stop?  Where can I find this
LVL 12

Accepted Solution

patrikt earned 2000 total points
ID: 19598681
In Replication Monitor you can find replication agents. There are diferent agent types depending on type of replication. Log Reader agent is dependent on distribution database, other agents will just fail if distribution will not be awailable. Stoping all agents is recomended.
If replication agents are scheduled for regular starts it is driven by SQL Server Agent service. Go to SQL Server Agent, Jobs and find apropriete jobs and disable it. Instead of disabling you can stop whole SQL Agent if not used for other work.
After move remember to start everything as before.

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question