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