Master DB files in the wrong location!?

• PompeyTID

  SSC Veteran

  Points: 219

  More actions

  April 18, 2005 at 7:35 pm

  #87289

  Hi all,

  I've inherited a SQL instance which has the master and model datafiles and transaction logs in the wrong location. What I want to do is move them, but am unsure how to do it?

  Model will be easy enough (detach, move files, reattach), but at a the master loss how to move the files which make up the master DB.

  Any advice will be gratefully received. Thanks.

• wz700

  SSCertifiable

  Points: 7133

  More actions

  April 18, 2005 at 11:43 pm

  #553319

  Backup master first (precaution).

  Stop the sql server.

  Regedit to modify master db location.

    lOCAL_MACHINE/SOFTWARE/MICROSOFT/MSSQLSERVER/MSSQLSERVER/PARAMETERS/SQLArg0 ~ SQLArg2

  Restart the sql server

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  April 19, 2005 at 12:56 am

  #553328

  See my article Moving system databases - a checklist, which describes exactly how to do this.

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

• StormNorm

  SSCommitted

  Points: 1653

  More actions

  April 20, 2005 at 8:51 am

  #553803

  Try this link for the master db:

  http://www.databasejournal.com/features/mssql/article.php/3379901

   

• DBAEngg

  Old Hand

  Points: 394

  More actions

  April 20, 2005 at 11:51 am

  #553860

  Hi,

  visit this to move system databases:

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

  Hope this will help you.

  Thanks.