|
 |
About Us | |
|
SSWUG Articles | |
 |
Articles | |
|
FAQ |
|
Administration | |
|
Backup/Restore | |
|
Connectivity | |
|
Development | |
|
General | |
|
Installation | |
|
OLAP | |
|
Replication | |
|
Transfer/move | |
|
Trouble | |
 |
SQL 6.5 |
|
Scripts | |
|
Tips | |
|
Test Exams | |
|
Advertise | |
|
Download | |
|
History | |
|
Search | |
|
Traffic | |
|
Related Links | |
|
||
|
|
||
 How do I remove the tempdb database from the master device? Answer: The tempdb database is created on the master database device. The default size of tempdb is 2 MB. You can move tempdb database from the master on its own device to simplify administering and monitoring. To move tempdb database from the master on its own device, try the following: 1. Create new device with appropriate size (tempdb_dev for example). 2. Uncheck "Default device" option for the master database device (this option is enable for the master database device by default). 3. Set "Default device" option for the tempdb_dev device. 4. From the Enterprise Manager (or sp_configure) set tempdb to be in RAM (set value to 1). 5. Stop and restart MSSQLServer service. 6. From the Enterprise Manager (or sp_configure) set tempdb to not be in RAM (set value to 0). 7. Stop and restart MSSQLServer service. See also this link: Some tips about tempdb database |