Moving SQL master Database in SQL 2005

October 17, 2008 by John Tran · 2 Comments 

  1. Launch SQL Server Configuration Manager
  2. Click on SQL Server 2005 Services and in the right panel right click on SQL Server (instance_name) and click on Properties
  3. On the Advanced tab, in the Startup Parameters box, type the parameters separated by semicolons (;).
  4. Current Startup Parameters: -dD:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eD:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lD:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
  5. Change the path of master.mdf and mastlog.ldf.
  6. New Startup Parameters: -dNew_Drive:\New_Path\master.mdf;-eD:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lNew_Drive:\New_Path\mastlog.ldf
  7. Stop SQL Server Service
  8. Move master.mdf and mastlog.ldf to new location.  Make sure that permission are correctly set on the new directory.  If you do not give appropriate access to SQL, the SQL Server Service will not start.
  9. Start SQL Server Service

About John Tran

Comments

2 Responses to “Moving SQL master Database in SQL 2005”
  1. Shashikant says:

    Please clarify what are the rights that we need to give to new folder where i need to copy master.mdf and mastlog.ldf.
    Thanks…..

  2. Moorthy says:

    Thank you very much. This article saved my day.

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!