Problem moving location of master db data/log files

[NWChowd]

Help!

Using SQL Server 2000, I tried to move the master database from its default location to a data only drive, specifically, I used the MS help file located at:

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

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.


The problem is that I stopped SQL Server, but cannot Restart it! I want to check to make sure I added the Startup Parameters correctly.

How do I do this?

======================================
"I wish that I may never think the smiles of the great and powerful a sufficient inducement to turn aside from the straight path of honesty and the convictions of my own mind."
-David Ricardo, classical economist
======================================

 

[mrdenny]

They are stored in the registry. It's in HRLM\Software\Microsoft\MSSQLServer\MSSQLServer\Parameters
The Key SQLArg0 is the -d
The Key SQLArg1 is the -E
The Key SQLArg2 is the -l

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)