-
Changing location of Master, msdb, tempdb, etc
When SQLserver2K was installed it placed master, model, msdb, tempdb data files in the installation location (i.e. C:\Program Files\....). This puts pressure on the C: drive, which also holds the page/swapfile. I want to move at least the tempdb location to the new 'Default data directory' and log directory we set after installation (i.e. E:\MSSQL\Data).
How do I get tempdb to relocate to E: given that it gets recreated each time SQLserver starts?
TIA,
Al
-
Follow instructions in Micorosoft kb article Q224071.
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
|
|