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 |
|
MichaelP
Jedi Yak
2489 Posts |
 Posted - 2004-04-29 : 11:52:01
|
| Hey All,Is there anyway to move the TempDB datafiles from one drive to another? Should I just add a new datafile on the "new" drive and just go with that?Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
cas_o
Posting Yak Master
154 Posts |
Posted - 2004-04-29 : 12:17:13
|
| Here ya go buddy.[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=34256[/url];-]... Quack Waddle |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-04-29 : 13:31:41
|
| Thanks!I guess I should take my own advice sometimes :)Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-29 : 13:42:16
|
| Just this past Monday, I moved the system databases around. SQL Server was installed so that the database files would go to F:\MSSQL2000. So that means F:\MSSQL2000\MSSQL... That's not our standard, so I wanted to move everything to F:\MSSQL... I used that article to move all of the databases. But then there was still stuff in MSSQL that needed to be moved such as FTDATA, JOBS, LOG, and REPLDATA directories. I knew the path information was stored in the registry, so I decided what the heck let's try modifying the registry. If it doesn't work, I'll just undo it. So I searched for MSSQL2000 and found all instances of it. I didn't bother changing the ones in the HKEY_USERS or HKEY_CURRENT_USERS. So after all of that was done, I moved the directories to the new path, started SQL Server and whatdayaknow, it worked! Now this was on the disaster recovery server in production. We were reconfiguring it anyway, which meant I had my shot at seeing if this would work. I would never do this on a production server without first trying it somewhere else. I still might not do this on a production server if that server was the one that the apps were pointing to as I wouldn't want to incur any extra downtime that is absolutely necessary. I would wait until we switched sites, which we do twice a year for practice and also so that we can make huge changes at the primary site.Tara |
|
|
|
|
|
|
|
|
Moving TempDB