Moving Paths

• joe435

  SSC Rookie

  Points: 38

  More actions

  April 22, 2002 at 12:35 pm

  #58193

  I would like to move the default paths of the master, msdb, model, etc. I am using sql 2000 and wish to have all of the database files on d:\sqldata\filename.mdf Is this possible. I know that I can dettach all of the regular databases and reattach them in the new folder. But this will not work with master, model, msdb. Does anyone know how to do such a thing. I appreciate any assistance with this issue.

  Thank You,

  John

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 22, 2002 at 3:15 pm

  #427620

  Here you go, all you ever wanted to know about the whole process for both 7 and 2K http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)