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.
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 GOtempdev 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 onlyfrom 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 onlytemp_dev E:\Data\tempdev_Data.NDF 14848 KB Unlimited 80 KB data onlywhat 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 |
|
|
|
|
|