How do I remove the tempdb database from master?

Neil Pike

March 4, 1999

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A. A. Do the following.

  1. Configure tempdb to be in RAM for 2 MB. Use SQL EM or sp_configure.

  2. Stop and restart SQL Server.

  3. Add a new device for tempdb. Do not call it temp_db - any other name should be ok

  4. 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.

  5. Configure tempdb to NOT be in RAM (set value to 0)

  6. Stop and restart SQL Server

  7. Re-mark whichever device(s) you want to be default.

Contributed by Neil Pike

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