My tempdb has gotten large and I am running out of disk space on the current drive. Also, I would like to separate it from the data files.
How do I move tempdb to a new drive?
asked Oct 28 '09 at 11:25 AM in Default
Steve Jones - Editor ♦♦
You would use the 'ALTER DATABASE' statement
TempDB is recreated every time the instance of SQL Server is started, so there is no need to move the physical files. When the instance is restarted the files will be created in the locations specified.
Until then tempDB will continue to use the data and log files in the existing location. Once the instance has been restarted, you can safely delete the old files.
Further info can be found here on MSDN.
answered Oct 28 '09 at 11:32 AM
Kev Riley ♦♦