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.
DataFieldAsked:
Who is Participating?
 
ptjcbConnect With a Mentor Commented:
From BOL:

You can configure an instance of SQL Server to start automatically each time you start the Microsoft Windows NT® 4.0 or Windows® 2000 operating system.


Since the OS did not restart, then SQL Server did not restart.
0
 
Kevin3NFCommented:
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.
0
 
DataFieldAuthor Commented:
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?
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
ptjcbCommented:
You should look at the event log on the server (application) to see if there were any events that caused the shutdown.
0
 
Kevin3NFCommented:
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:
http://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....
0
 
jrb1Commented:
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.)
0
 
DataFieldAuthor Commented:
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?

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.