Moving the Tempdb and Master Database in SQL Server 2000

  • 1. AceProject 1.JPG

    There have been many occasions where I found it necessary to move the database and log files to different drives to increase performance. When you want to move a typical user database to a different drive for performance or to split out the logs, you run sp_detach and sp_attach to perform the move. However, when it comes to moving the Master and Tempdb database, different rules apply.

    Wally
  • 2. PPM Roadmap 1.JPG
    Wally
  • 3. Zoho 0.JPG
    Wally
  • 4. OSRMT 1.JPG
    Wally
  • 5. Planware 1.JPG
    Wally
1 of 5
Steven S. Warren

Steven S. Warren lives in sunny Florida. His articles and blogs have appeared on websites such as CIO Update, DevX, TechRepublic, SearchTechTarget, Datamation and DatabaseJournal. With more than 15 years of experience writing about…