June 28, 2004 at 9:41 am
Does anyone know how to move the distribution database?
June 28, 2004 at 1:51 pm
David, I assume you'd move it like you'd move any of the system dbs. Is this moving to a new location on the same server? Or a new server?
MS Ref: http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
June 29, 2004 at 1:34 am
It is moving it on the same server.
I'm asking more for curiosity sake than anything.
As standard practice I use the articles you wrote on moving databases to put the system databases into their own folder. This is mainly because I like to keep system stuff well away from user stuff.
I notice that the initial install data directory has the Distribution database files, but there doesn't seem to be a registry setting or database record that identifies where those files are held, until you configure your server for replication, by which time it is too late.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply