How do I move TempDB to it's own device?

[Mark Blackburn]

I want to duplicate the environment of another existing server where tempdb
resides on it's own device (200mb in size). I can create the devices (data & log). What do
I have to do to physically move tempdb to the new devices I create? I've seen such
articles on Swynk.com, but today the links are not working. Thanks very much!


Mark Blackburn o `\"._ _ M onterey
mark@mbari.org o / _ |||;._/ ) B ay
Science at its Best! ~ _/@ @ /// ( ~ A quarium
(831) 775-1880 ( (`__, ,`| R esearch
http://www.mbari.org/ '.\_/ |\_.' I nstitute

Database Administrator
MBARI Personal Web Page: http://www.mbari.org/~mark/

[Al]

Hi Mark,

It goes like this:

1. Put your temp in RAM
2. Start your sqlserver with minimal configuration (temp is now in RAM)
3. Set your new temp device as default device
4. Set Temp in RAM 0
5. restart sqlserver

www.swynk.com/faq/sql/sqlfag_tqansfer.asp
http://support.microsoft.com/support/kb/articles/q187/8/24.asp


Put tempdb data&log on one devices. Don't separate, cause later you can't expand easily (only log expands)

Good luck,
Al


------------
Mark Blackburn at 6/18/99 3:41:41 PM

I want to duplicate the environment of another existing server where tempdb
resides on it's own device (200mb in size). I can create the devices (data & log). What do
I have to do to physically move tempdb to the new devices I create? I've seen such
articles on Swynk.com, but today the links are not working. Thanks very much!


Mark Blackburn o `\"._ _ M onterey
mark@mbari.org o / _ |||;._/ ) B ay
Science at its Best! ~ _/@ @ /// ( ~ A quarium
(831) 775-1880 ( (`__, ,`| R esearch
http://www.mbari.org/ '.\_/ |\_.' I nstitute

Database Administrator
MBARI Personal Web Page: http://www.mbari.org/~mark/