Moving The Distribution Model Files

I am currently moving the system databases data and log files to different d
rives. I know how to move the master, model, log, and tempdb but can find no
documentation on how to move the distribution model files (distmdl.mdf and
distmdl.ldf). Does anyone k
now how these files should be moved? As an added note, we are not currently
using distribution, but the files still exist. Any information would be grea
tly appreciated.Just copy them to where you put master. You don't actually need them to set
up replication but it makes it a lot faster (the set up that is, not
replication in general) as otherwise it has to create it all from scripts.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:CDCA750A-64C7-4A6D-B985-C06BBA09DFC2@.microsoft.com...
> I am currently moving the system databases data and log files to different
drives. I know how to move the master, model, log, and tempdb but can find
no documentation on how to move the distribution model files (distmdl.mdf
and distmdl.ldf). Does anyone know how these files should be moved? As an
added note, we are not currently using distribution, but the files still
exist. Any information would be greatly appreciated.
>|||Jasper, Thanks for the quick reply. I searched all over the KB and could fin
d nothing about this.
Mike C.
"Jasper Smith" wrote:

> Just copy them to where you put master. You don't actually need them to se
t
> up replication but it makes it a lot faster (the set up that is, not
> replication in general) as otherwise it has to create it all from scripts.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "MACason" <MACason@.discussions.microsoft.com> wrote in message
> news:CDCA750A-64C7-4A6D-B985-C06BBA09DFC2@.microsoft.com...
> drives. I know how to move the master, model, log, and tempdb but can find
> no documentation on how to move the distribution model files (distmdl.mdf
> and distmdl.ldf). Does anyone know how these files should be moved? As an
> added note, we are not currently using distribution, but the files still
> exist. Any information would be greatly appreciated.
>
>|||I would leave those distribution template databases where they were. But if
you are also changing the default database and log folders, then copy these
templates into those folders.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:CDCA750A-64C7-4A6D-B985-C06BBA09DFC2@.microsoft.com...
> I am currently moving the system databases data and log files to different
drives. I know how to move the master, model, log, and tempdb but can find
no documentation on how to move the distribution model files (distmdl.mdf
and distmdl.ldf). Does anyone know how these files should be moved? As an
added note, we are not currently using distribution, but the files still
exist. Any information would be greatly appreciated.
>