moving tempdb into another drive

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

moving tempdb into another drive

Author

Topic

rajajuliana
Starting Member

4 Posts

Posted - 2008-11-10 : 03:13:06

hi..
i already moved tempdb files from c: drive to e drive:,
the problem is, the database still using/read the datafiles at c: drive..

USE TempDB
GO
EXEC sp_helpfile
GO

tempdev 1 C:\MSSQL\data\tempdb.mdf PRIMARY 540672 KB Unlimited 10240 KB data only
templog 2 C:\MSSQL\data\templog.ldf NULL 512 KB Unlimited 0 KB log only
temp_dev 3 E:\Data\tempdev_Data.NDF PRIMARY 14848 KB Unlimited 80 KB data only
temp_log 4 E:\Log\templog_Log.LDF NULL 9216 KB Unlimited 80 KB log only

from the output, the DB still read C:\MSSQL\data\tempdb.mdf, which it cause the
c drive running low space. am i suppose to remove the automatic file growth options at c: drive? and do i need to restart the service?

thanks in advanced.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-10 : 03:45:29

quote:
To move tempdb to another drive run this and restart SQL Server…

ALTER DATABASE tempdb
MODIFY FILE ( NAME = templog , FILENAME = 'f:\sql2000\templog.ldf' )

ALTER DATABASE tempdb
MODIFY FILE ( NAME = tempdev , FILENAME = 'f:\sql2000\tempdev.mdf' )

ALTER DATABASE tempdb
MODIFY FILE ( NAME = tempdev2, FILENAME = 'f:\sql2000\tempdev2.mdf' )

ALTER DATABASE tempdb
MODIFY FILE ( NAME = tempdev3, FILENAME = 'f:\sql2000\tempdev3.mdf' )

ALTER DATABASE tempdb
MODIFY FILE ( NAME = tempaug, FILENAME = 'f:\sql2000\tempaug.mdf' )

E 12°55'05.63"
N 56°04'39.26"

rajajuliana
Starting Member

4 Posts

Posted - 2008-11-10 : 21:13:22

dear Peso,

thanks for the reply. i already moved the datafile from c: to e: drive,
but the database still read from c: drive.

tempdev C:\MSSQL\data\tempdb.mdf 540672 KB Unlimited 10240 KB data only
temp_dev E:\Data\tempdev_Data.NDF 14848 KB Unlimited 80 KB data only

what can i do to make the database read from e: drive rather than c: drive?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-10 : 21:35:27

You need to restart services.

rajajuliana
Starting Member

4 Posts

Posted - 2008-11-12 : 01:51:19

problem solved.. thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources