How to re-directory of Master and model dbs

Hi All,
Anyone know how to change the directory of system dbs -- master and model dbs? Thanks.I mean changing the directory of system db data files.|||http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

Tim S|||Check these links:

http://www.databasejournal.com/features/mssql/article.php/1458131
http://www.sqlteam.com/item.asp?ItemID=10060
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071|||Hi Guys,

I tried to use the infor you guys providing for me to moved the msdb, was ok. but as moving Master db, I changed the startup Parameters using new location, then tried to restart the SQL server which was failed, got error message:"Could not start the MSSqlserver service on local computer. Error 1067: The process terminated unexpectedly".

Any suggestiongs??

Thanks.|||Did you move MDF and LDF files to the location that you specified in startup parameters?|||Yes, I moved both of them.|||Did you move anything else like MODEL?|||No, I didn't move Model only Master.|||This is the steps I did:

Moving the master database
1. Change the path for the master data and log files in SQL Server Enterprise Manager.

Note You may optionally change the location of the error log here as well.
2. Right-click the SQL Server in Enterprise Manager and click Properties.
3. Click the Startup Parameters button and you will see the following entries: -dD:\MSSQL7\data\master.mdf
-eD:\MSSQL7\log\ErrorLog
-lD:\MSSQL7\data\mastlog.ldf

-d is the fully qualified path for the master database data file.

-e is the fully qualified path for the error log file.

-l is the fully qualified path for the master database log file.
4. Change these values as follows: a. Remove the current entries for the Master.mdf and Mastlog.ldf files.
b. Add new entries specifying the new location: -dE:\SQLDATA\master.mdf
-lE:\SQLDATA\mastlog.ldf



5. Stop SQL Server.
6. Copy the Master.mdf and Mastlog.ldf files to the new location (E:\Sqldata).
7. Restart SQL Server.

Now last step was failed. Failed to restart SQL server. The error is " An error 1058 -- ( The service connot be started, either because it is disabled or because it has no enabled devices asociated with it ) occurred while performing this service operation on the MSSQL server service.

Any solutions Please? Thanks.|||Hi,

I checked the service porperty--Log on button-- Hardware Profile, disabled it and enabled it , then start the service again, the previous error message just gone , but other error coming out"Could not start the MSSqlserver service on local computer. Error 1067: The process terminated unexpectedly". I checked all possibility, but still no any clues.

Help !!!! Please!!!|||Try checking the sql server logs, event viewer to have an indication of what is going wrong ...|||I checked both of them yesterday: event view was empty, and sql server error log is :

2004-10-13 14:15:30.53 spid51 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..

2004-10-13 14:15:30.64 spid51 Using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_msver'.

2004-10-13 14:26:20.26 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager."

I tried to put the original startup parameters back at MSSQL service property window on log on button-- startup parameter.

it's still failed and nothing recorded at event view and error log too.|||I think you have a typo in the "Startup Parameters"

I Might be able to help you fix it, but need more info.

What is the exact paths to the following files?

master.mdf
ERRORLOG
mastlog.ldf

What OS are you running?

I am assuming SQL 2000 SP3, correct?

Tim S|||Thanks a lot Tim.

My OS is window 2000, and Sql server is sp3. The Mater original path is :

-dD:\Database Files\MSSQL\Data\master.mdf
-eD:\Database Files\MSSQL\Data\Log\ERRORLog
-lD:\Database Files\MSSQL\Data\mastlog.ldf

The new path I changed is:

-dD:\Database Files\Master\master.mdf
-eD:\Database Files\MSSQL\Data\Log\ERRORLog (this one was not changed)
-lD:\Log Files\Master\mastlog.ldf

Thanks.|||REGEDIT4

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\Parameters]
"SQLArg0"="-dD:\\Database Files\\Master\\master.mdf"
"SQLArg1"="-eD:\\Database Files\\MSSQL\\Data\\Log\\ERRORLOG"
"SQLArg2"="-lD:\\Log Files\\Master\\mastlog.ldf"

Save above in a file ending with .reg
Then Click on the file This will set the default instance of SQL Server to the paths you gave for the master.

If it was just a typo should fix it.

Tim S|||Well, your error just does not make any sense, unless you misspelled the location of the files. It's that simple! No misteries! SQL Server service will start with -d and -l parameters for as long as the path specified actually contains the MDF and LDF files for master (providing nothing else got screwed up). Check the spelling and make sure you tell us the truth, otherwise, - you are making us all feel unworthy ;)|||Help!!!!!Please.|||Since you can't seem to figure out where sql server is looking for the master database, you might have to use the rebuildm utility to let sql server create a new set of system databases and then replace the newly created databases with yours by copying them over. Then you can try moving them again with the help in this thread, because it works if done right.

Be sure to stop sql sever and copy your system databases to a safe location (where they will not be overwritten !!) before running the utility. Also, read this first ... http://support.microsoft.com/default.aspx?scid=kb;en-us;273572|||Rebuild might be the last way.

I just don't get it: I check the registry, all the path in parameter folder are correct, no typo error and I tried to change back to original path, it's still not working. The error message is the same.

Any sugestions!!!!!

Thanks!