April 25, 2009 at 3:03 pm
I found that the person who installed Sql 2005 allowed all the system databases to go to the C: drive.
I want to move these db's off of C:, but I am reading that if you have replication going to not move the distribution db & log file or you have to tear repl. down & rebuild it. I don't really want to do this.....so my question;
Is there any issue with moving all the other system db's & log files to different drives & leave the distribution db & log where they are?
thanx
April 25, 2009 at 5:18 pm
It would work fine, SQL won't care that the distribution database is in a different location.
However, if you stop replication by disabling the agents, ensure its quiesced and no pending transactions (stop the app involved if you can) and move the distribution database by backup and restore with move, and set dbowner back to its current value, you can move it without removing replication.
Of course, script out replication set up first.
---------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply