| Home |
| Articles |
| Backup |
| Books |
| Certification |
| FAQ |
| Products |
| Replication |
| Scripts |
| Seminars |
| Training |
| TSQL |
|
| MSDN Fourms |
| Philippine SSUG |
| Fort Worth SSUG |
| Oklahoma City SSDG |
|
| Resume |
|
| MHS Enterprises |
| BlowFrog Software |
| FilAm Software |
| AcrylicAcetate.com |
| Bargain Humidors |
| Western Humidor |
|
|
How do I remove the tempdb
database from master/default devices?
Do the following for SQL 6.5 and below
- 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.
For SQL 7.0 :-
- alter database tempdb alter file <logicalname> filename = <newlocation> ....
- Stop and restart Sql Server
|
