Results 1 to 2 of 2

Thread: Changing location of Master, msdb, tempdb, etc

  1. 11-03-2003, 12:00 PM #1
    Al Gill
    Al Gill is offline Registered User
    Join Date
    Nov 2002
    Location
    Bellingham, WA
    Posts
    34

    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
    Reply With Quote Reply With Quote
  2. 11-03-2003, 12:08 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Follow instructions in Micorosoft kb article Q224071.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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