How do I remove the tempdb database from master?
Neil Pike
March 4, 1999
1 Min Read
A. A. Do the following.
Configure tempdb to be in RAM for 2 MB. Use SQL EM or sp_configure.
Stop and restart SQL Server.
Add a new device for tempdb. Do not call it temp_db - any other name should be ok
Make that new device a 'default' device; make sure no other device is marked as default, especially master. You can check/change default status either using SQL EM, or the sp_diskdefault stored-procedure. Both are fully described in the books-online.
Configure tempdb to NOT be in RAM (set value to 0)
Stop and restart SQL Server
Re-mark whichever device(s) you want to be default.
Contributed by Neil Pike
About the Author
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
You May Also Like