Move System DBs to new drive

• dean gross

  SSCrazy

  Points: 2632

  More actions

  November 18, 2004 at 9:07 am

  #85996

  How can I move the system databases (model, msdb and master) to my new drive? This is on a development PC using SQL 2000.

   

  TIA

  Dean

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736602

  More actions

  November 18, 2004 at 9:52 am

  #530704

  http://www.sqlservercentral.com/columnists/sjones/moveyourmaster.asp

  http://www.sqlservercentral.com/columnists/sjones/movingmsdb.asp

  http://www.sqlservercentral.com/columnists/sjones/atemporarymove.asp

• Jimmy Jen

  SSCrazy

  Points: 2915

  More actions

  November 18, 2004 at 9:55 am

  #530706

  see link below which shows step by step instructions:

  http://support.microsoft.com/kb/q224071/