Moving Master, tempdb and model data and log files

• Jpotucek

  SSCoach

  Points: 18583

  More actions

  June 14, 2005 at 8:27 am

  #362888

  I performed a new install of SQL Server 2000 and before I begin populating it with new databases, i would like to move the 'System' database data and log files to a different drive.    I have been poking around on the internet and have searched on this site but cannot find out how to do this...  can anyone help?

• gbn

  SSCertifiable

  Points: 6429

  More actions

  June 14, 2005 at 8:28 am

  #565338

  See http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

  This tells you how to shift system dbs...

• bulld0g77

  Mr or Mrs. 500

  Points: 572

  More actions

  June 14, 2005 at 8:32 am

  #565342

  Check out the post on this forum (a few messages down) named "RE: Help! Can't restart SQL Server after detaching msdb" before you make the same mistake I did when using Microsoft's instructions.

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  June 14, 2005 at 9:37 am

  #565384

  I have a checklist published here at SQLServerCentral.com which describes these steps, adapted from the Microsoft article linked above.

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/

• Jpotucek

  SSCoach

  Points: 18583

  More actions

  June 14, 2005 at 10:08 am

  #565394

  Thank you for the advice and help!