Expanding tempdb

[Lehtoant]

Hi,<br>
<br>
I herited a database where tempdb and its log were on two separate devices. Expanding database expands only the log.<br>
<br>
The only solution I figured out was to:<br>
- put first tempdb in RAM<br>
- restart server with minimal configuration /f<br>
- set master as default device and set tempdb in RAM as 0<br>
- restart server and make a new disk device for tempdb and set as default<br>
- restart server and expand tempdb (data&log) to new and THE ONLY ONE tempdb device<br>
- and of course, backup FIRST<br>
<br>
Is there any other solution or procedure to make this easier?<br>
<br>
Done it and hopefully never again,<br>
Al

 

[vkohli]

I encountered this problem at a client site. i found out that we had to do what you mentioned. Otherwise, the option was to re-install SQL Server with tempdb rebuilt as a new database.

 

[bporter]

I've moved tempdb around and resized it using a smilar approach, except I saw no need to restart with the minimal flag. Basic steps I did were:<br>
<br>
- create new default device of desired size<br>
- move to RAM, 2 MB<br>
- restart<br>
- move from RAM<br>
- restart<br>
- expand tempdb to fill the new device it landed on<br>
<br>
Still sort of icky, but I did not find it to be too painful.