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"
Go to Top of Page

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?


Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-10 : 21:35:27
You need to restart services.
Go to Top of Page

rajajuliana
Starting Member

4 Posts

Posted - 2008-11-12 : 01:51:19
problem solved.. thanks
Go to Top of Page
   

- Advertisement -