Can't start SQL Server 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Moishe Much - 07 Mar 2008 11:27 GMT

We are trying to move msdb, model and master. We added the -c -m and -T3608
to the startup parameters. When we try to restart SQL fails to start. The
error is that it cannot find master database and will not start. We cannot
get back into Enterprise Manager to reset the startup parameters. How can
we reset the parameters and, more importantly, restart SQL Server?

Thanks very much in advance.

Reply to this Message

Tibor Karaszi - 07 Mar 2008 12:52 GMT

First step is to look in SQL Servers errorlog file for the reason why SQL Server won't start.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> We are trying to move msdb, model and master. We added the -c -m and -T3608
> to the startup parameters. When we try to restart SQL fails to start. The
[quoted text clipped - 3 lines]
>
> Thanks very much in advance.

Reply to this Message

Dan Guzman - 07 Mar 2008 13:03 GMT

> We are trying to move msdb, model and master. We added the -c -m
> and -T3608
[quoted text clipped - 4 lines]
> can
> we reset the parameters and, more importantly, restart SQL Server?

The parameters for a default SQL 2000 instance are in the registry under:

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer\Parameters

If it SQL Server can't find master at startup, you probably didn't specify
the correct master database path parameter.

Signature

Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

> We are trying to move msdb, model and master. We added the -c -m
> and -T3608
[quoted text clipped - 6 lines]
>
> Thanks very much in advance.

Reply to this Message