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.
**************************
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.
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?
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....
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....
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'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.)
ASKER
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?
But why it didn't restart automatically as usual?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
When you have no message at all, its a SQL Server hang.