-
How do I move TempDB to it's own device?
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/
-
How do I move TempDB to it's own device? (reply)
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/
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|