Moving SQL master Database in SQL 2005
October 17, 2008 by John Tran · 2 Comments
- Launch SQL Server Configuration Manager
- Click on SQL Server 2005 Services and in the right panel right click on SQL Server (instance_name) and click on Properties
- On the Advanced tab, in the Startup Parameters box, type the parameters separated by semicolons (;).
- 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
- Change the path of master.mdf and mastlog.ldf.
- 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
- Stop SQL Server Service
- 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.
- Start SQL Server Service
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…..
Thank you very much. This article saved my day.