January 23, 2008 at 9:58 am
We have a distributor server using immediate replication and, of course, a distributor database. (All servers involved are SS 2000 SP4.) I need to move the distributor to a new drive and don't want to redo replication as the tables involved are very large. I can't find the KB article or link that shows me how to move the distributor to a new drive on a distributor server for SS 2000. How can I do this and read about this?
January 24, 2008 at 1:02 am
Hi,
I have a feeling that it is not possible to move the distribution database.
You might have to remove replication entirely so that the distribution database files are created on the new drive.
...I could be wrong however.
Regards
Graeme
January 25, 2008 at 5:18 am
it's simpler than you think:
script out replication first (just in case and so you can easily recreate)
quiesce replication (including all check agents that access distribution database)
check no commands to be distributed
(dbcc opentran in published database)
backup distribution database
restore distribution database using WITH MOVE option to move files where you want them
restart replication
....er , thats it
---------------------------------------------------------------------
January 25, 2008 at 5:23 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply