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 |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2002-06-27 : 08:39:11
|
| I need to move the tempdb onto another drive. What is the best way to do this.Can I sp_attatch / detatch?This box is running SQL 7.0Thanks in advanceslow down to move faster... |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-06-27 : 08:49:54
|
| ALTER DATABASE tempdb MODIFY FILE (NAME = 'TEMPDEV', FILENAME = 'F:\TEMPDEV.MDF')Then do the same for the log file. Stop/start the service, and the files will be created in the new location. Edited by - izaltsman on 06/27/2002 08:51:10 |
 |
|
|
|
|
|
Move TempDB