Link to home
Start Free TrialLog in
Avatar of DataField
DataField

asked on

SQL Server is terminating due to 'stop' request from Service Control Manager.

The sql sever 2000 stopped unexpectly yeserday around 9pm,

**********************************
2005-04-09 21:00:19.02 spid3     SQL Server is terminating due to 'stop' request from Service Control Manager.
**********************************

no sure what casue it. There is log backup is scheduled every 15 minutes.
Avatar of Kevin Hill
Kevin Hill
Flag of United States of America image

That is a normal shutdown message...same thing you would see if you went into the SCM (icon in the lower right corner and shut down the service manully, or from Control Panel.

When you have no message at all, its a SQL Server hang.
Avatar of DataField
DataField

ASKER

The sql server stopped around 9pm, and I found it and started on 10:40pm manually.

Usually what is the reason cause the SQL server to stop?

Also I set the server to 'Autostart SQL server', why it doesn't start automatically?
You should look at the event log on the server (application) to see if there were any events that caused the shutdown.
Also, just so you know, there is a technical area here on EE specifically for SQL Server that gets more traffic than this one does:
https://www.experts-exchange.com/Databases/Microsoft_SQL_Server/

Might get some additional responses since the bulk of your questions appear to be SQL Server related....
Avatar of jrb1
First, check all log files.  If you can see anything, this may be memory related.  Can you monitor your memory (with Performance monitor)?  

I've also seen recommendations to reserve more physical memory for SQL server as well as define a maximum limit for memory usage by SQL server (in Enterprise manager by right-clicking your server and choosing properties.)
I just asked my IT system manager, actually there was 'off-line system backup' scheduling at that time. That is why the SQL server stopped. Usually the SQL server would be down for 1:30 mintues.

But why it didn't restart automatically as usual?

ASKER CERTIFIED SOLUTION
Avatar of ptjcb
ptjcb
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial