Moved Master DB and Error log - Now MSSQL Will Not Start 2

[JohnBates]

hi all,

This is SQL Server 2000 Std SP3a

Using Microsoft's "How to move SQL Server databases to a new location" document, I successfully moved msdb and model.

I did this by changing the Startup parrameters for the SQL Server service.

Everything worked well until I got to the master db.
** I accidentally enter -lE:\SQL1\MSSQL\DATA\mastlog.mdf"

Of course that should have been \mastlog.ldf !

Now SQL Server will not start, and error log shows that
it cannot find mastlog.mdf.

My questions are:
1. where are these startup parms stored?
2. how can I change them to the correct path if I can't start SQL Server?
3. Will I have to do a complete reinstall of SQL Server 2000 to resolve this problem?

Thanks very much for any ideas.
John

 

[vongrunt]

Can you stop server, run it manually from command prompt with correct parameters, then use EM to fix bad ones?

------
[small]<this is sig>
select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')
</this is sig>[/small]

 

[mrdenny]

These startup paramaters are stored in the system registry.
HKLM_SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters\

They can be changed there then you should be able to restart SQL.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

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

http://www.mrdenny.com

 

[JohnBates]

yep mrdenny. A few minutes ago, I found another post where you had mentioned these parms being stored in the registry so I edited that and it worked like a charm.

Thanks a lot! John

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

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

http://www.mrdenny.com