Moving The Distribution Model Files

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 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 greatly 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 find nothing about this.
Mike C.
"Jasper Smith" wrote:

> 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...
> 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.
>

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.
>

Moving tempdb onto a faster drive

Hello all ...

is there a standard procedure or document that explains how to:

Expand tempdb onto a faster drive ... making it larger

then ...

Remove the small portion of tempdb from my c:\ drive to reduce contention?

Thanks!

Doug

So you want to move tempdb to a new location, correct? This should work on SQL 2005, it might work on SQL 2000 as well. See topic "Moving System Databases" in SQL 2005 books online: http://msdn2.microsoft.com/en-us/library/ms345408.aspx

|||

Yup, exactly what I wanted ... move tempdb on to a larger, faster drive with no contention w/ the Windows OS and paging.

Thanks so much!

DB

Moving TempDB files

What is the best way to move the TempDB files from say Drive C to Drive D
(same hard disk)?
Thanks very much.
Hi Amos,
I usually use the following:
use master
go
Alter database tempdb modify file (name = tempdev, filename =
'H:\newTempDBLocation\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename =
'H:\newTempDBLocation\templog.ldf')
Go
Restart SQL Server service and remove files from old location afterwards.
Michael Zilberstein
DBArt
Senior Consultant
My blog: http://sqljunkies.com/WebLog/mz1313
"Amos Soma" wrote:

> What is the best way to move the TempDB files from say Drive C to Drive D
> (same hard disk)?
> Thanks very much.
>
>
|||Search books online. Explicit example in there IIRC.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Amos Soma" <amos_j_soma@.yahoo.com> wrote in message
news:uxEPldRmIHA.4664@.TK2MSFTNGP06.phx.gbl...
> What is the best way to move the TempDB files from say Drive C to Drive D
> (same hard disk)?
> Thanks very much.
>
|||Everything you need are in this amazing articles. Keep it in safe!
http://support.microsoft.com/kb/224071/en-us
Sds!
Amos Soma wrote:
>What is the best way to move the TempDB files from say Drive C to Drive D
>(same hard disk)?
>Thanks very much.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200804/1

Moving TempDB files

What is the best way to move the TempDB files from say Drive C to Drive D
(same hard disk)?
Thanks very much.Hi Amos,
I usually use the following:
use master
go
Alter database tempdb modify file (name = tempdev, filename ='H:\newTempDBLocation\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename ='H:\newTempDBLocation\templog.ldf')
Go
Restart SQL Server service and remove files from old location afterwards.
--
Michael Zilberstein
DBArt
Senior Consultant
--
My blog: http://sqljunkies.com/WebLog/mz1313
"Amos Soma" wrote:
> What is the best way to move the TempDB files from say Drive C to Drive D
> (same hard disk)?
> Thanks very much.
>
>|||Search books online. Explicit example in there IIRC.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Amos Soma" <amos_j_soma@.yahoo.com> wrote in message
news:uxEPldRmIHA.4664@.TK2MSFTNGP06.phx.gbl...
> What is the best way to move the TempDB files from say Drive C to Drive D
> (same hard disk)?
> Thanks very much.
>|||Everything you need are in this amazing articles. Keep it in safe!
http://support.microsoft.com/kb/224071/en-us
Sds!
Amos Soma wrote:
>What is the best way to move the TempDB files from say Drive C to Drive D
>(same hard disk)?
>Thanks very much.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200804/1

Moving tempdb

How do I move tempdb to another drive on the same server?
Thanks
EmmaThe syntax is :- ALTER DATABASE tempdb MODIFY FILE ...
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/defaul...b;en-us;Q224071
HTH. Ryan
"Emma" <Emma@.discussions.microsoft.com> wrote in message
news:A653420A-D77D-4DD5-B041-94B70D9D205E@.microsoft.com...
> How do I move tempdb to another drive on the same server?
> Thanks
> Emma|||Please ignore this message. Found the information at
21120120" target="_blank">http://support.microsoft.com/defaul...br />
21120120
Thanks
"Emma" wrote:

> How do I move tempdb to another drive on the same server?
> Thanks
> Emma

Moving tempdb

Hi,
We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
Tempdb is around 5GB or 7GB in size and is killing performance.
We want to move tempdb to a volume on the machine (e.g. T which has 40GB
free) so that we do not cause any problems on C:\.
Can you please tell me how we do this. Maybe links on the web with step by
step instructions would be useful.
SkcYou will find it in BOL, look for "Moving tempdb".
AMB
"Skc" wrote:
> Hi,
> We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
> Tempdb is around 5GB or 7GB in size and is killing performance.
> We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> free) so that we do not cause any problems on C:\.
> Can you please tell me how we do this. Maybe links on the web with step by
> step instructions would be useful.
> Skc|||there is an example in BOL, under "ALTER DATABASE", look for "Move the tempdb
database".
AMB
"Alejandro Mesa" wrote:
> You will find it in BOL, look for "Moving tempdb".
>
> AMB
>
> "Skc" wrote:
> > Hi,
> >
> > We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
> > Tempdb is around 5GB or 7GB in size and is killing performance.
> >
> > We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> > free) so that we do not cause any problems on C:\.
> >
> > Can you please tell me how we do this. Maybe links on the web with step by
> > step instructions would be useful.
> >
> > Skc|||As I replied within .setup:
The steps are described within this KB article:
http://support.microsoft.com/?id=224071
--
Keith
"Skc" <Skc@.discussions.microsoft.com> wrote in message
news:3DA1E004-3A30-4524-BCE9-539F3EBF1123@.microsoft.com...
> Hi,
> We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
> Tempdb is around 5GB or 7GB in size and is killing performance.
> We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> free) so that we do not cause any problems on C:\.
> Can you please tell me how we do this. Maybe links on the web with step
by
> step instructions would be useful.
> Skcsql

Moving tempdb

Hi,
We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
Tempdb is around 5GB or 7GB in size and is killing performance.
We want to move tempdb to a volume on the machine (e.g. T which has 40GB
free) so that we do not cause any problems on C:\.
Can you please tell me how we do this. Maybe links on the web with step by
step instructions would be useful.
Skc
You will find it in BOL, look for "Moving tempdb".
AMB
"Skc" wrote:

> Hi,
> We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
> Tempdb is around 5GB or 7GB in size and is killing performance.
> We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> free) so that we do not cause any problems on C:\.
> Can you please tell me how we do this. Maybe links on the web with step by
> step instructions would be useful.
> Skc
|||there is an example in BOL, under "ALTER DATABASE", look for "Move the tempdb
database".
AMB
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> You will find it in BOL, look for "Moving tempdb".
>
> AMB
>
> "Skc" wrote:
|||As I replied within .setup:
The steps are described within this KB article:
http://support.microsoft.com/?id=224071
Keith
"Skc" <Skc@.discussions.microsoft.com> wrote in message
news:3DA1E004-3A30-4524-BCE9-539F3EBF1123@.microsoft.com...
> Hi,
> We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
> Tempdb is around 5GB or 7GB in size and is killing performance.
> We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> free) so that we do not cause any problems on C:\.
> Can you please tell me how we do this. Maybe links on the web with step
by
> step instructions would be useful.
> Skc

Moving tempdb

Hi,
We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
Tempdb is around 5GB or 7GB in size and is killing performance.
We want to move tempdb to a volume on the machine (e.g. T which has 40GB
free) so that we do not cause any problems on C:\.
Can you please tell me how we do this. Maybe links on the web with step by
step instructions would be useful.
SkcYou will find it in BOL, look for "Moving tempdb".
AMB
"Skc" wrote:

> Hi,
> We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
> Tempdb is around 5GB or 7GB in size and is killing performance.
> We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> free) so that we do not cause any problems on C:\.
> Can you please tell me how we do this. Maybe links on the web with step b
y
> step instructions would be useful.
> Skc|||there is an example in BOL, under "ALTER DATABASE", look for "Move the tempd
b
database".
AMB
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> You will find it in BOL, look for "Moving tempdb".
>
> AMB
>
> "Skc" wrote:
>|||As I replied within .setup:
The steps are described within this KB article:
http://support.microsoft.com/?id=224071
Keith
"Skc" <Skc@.discussions.microsoft.com> wrote in message
news:3DA1E004-3A30-4524-BCE9-539F3EBF1123@.microsoft.com...
> Hi,
> We have a Dell PowerEdge with 12GB assigned to C. We have noticed that
> Tempdb is around 5GB or 7GB in size and is killing performance.
> We want to move tempdb to a volume on the machine (e.g. T which has 40GB
> free) so that we do not cause any problems on C:\.
> Can you please tell me how we do this. Maybe links on the web with step
by
> step instructions would be useful.
> Skc

moving system DB files

I would like to move the files for msdb, model and tempdb into a different
directory. Can someone please tell me what is the cleanest way to move the
files? Thanks.
Here's a knowledge base article on doing exactly that:
http://support.microsoft.com/default...b;en-us;224071
Good luck,
Tony Sebion
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in
message news:594874C0-AE30-4BB1-BA2D-850A709A390E@.microsoft.com:

> I would like to move the files for msdb, model and tempdb into a different
> directory. Can someone please tell me what is the cleanest way to move the
> files? Thanks.

moving system DB files

I would like to move the files for msdb, model and tempdb into a different
directory. Can someone please tell me what is the cleanest way to move the
files? Thanks.Here's a knowledge base article on doing exactly that:
http://support.microsoft.com/defaul...kb;en-us;224071
Good luck,
Tony Sebion
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in
message news:594874C0-AE30-4BB1-BA2D-850A709A390E@.microsoft.com:

> I would like to move the files for msdb, model and tempdb into a different
> directory. Can someone please tell me what is the cleanest way to move the
> files? Thanks.

moving system DB files

I would like to move the files for msdb, model and tempdb into a different
directory. Can someone please tell me what is the cleanest way to move the
files? Thanks.Here's a knowledge base article on doing exactly that:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
Good luck,
Tony Sebion
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in
message news:594874C0-AE30-4BB1-BA2D-850A709A390E@.microsoft.com:
> I would like to move the files for msdb, model and tempdb into a different
> directory. Can someone please tell me what is the cleanest way to move the
> files? Thanks.

Moving sysdbs in sql2005

Hi,
Anyone know where I could find docs for moving sys dbs(master, msdb and
tempdb) in sql2005.
I used instruction for moving sql2000 sysdb. it's doesn't work.
ThnaksSee the topic "Moving System Databases" in Books Online.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23It9mX$VGHA.3284@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Anyone know where I could find docs for moving sys dbs(master, msdb and
> tempdb) in sql2005.
> I used instruction for moving sql2000 sysdb. it's doesn't work.
> Thnaks
>

Moving Model and tempdb

Hi!
After i Upgraded my SQL 7 to SQL 2000 my model and tempdb
database is still in th old location(C:\MSSQL7\Data). How
can i Move it. I have traid all.
Best Regards!
/Jens Nilsson
Database Administrator
Malmo - SwedenHave you looked at this
http://support.microsoft.com/?kbid=224071
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Jens Nilsson" <sqlis.mas@.skane.se> wrote in message
news:069401c35cb0$37db6330$a601280a@.phx.gbl...
> Hi!
> After i Upgraded my SQL 7 to SQL 2000 my model and tempdb
> database is still in th old location(C:\MSSQL7\Data). How
> can i Move it. I have traid all.
> Best Regards!
> /Jens Nilsson
> Database Administrator
> Malmo - Sweden