• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 18404
  • Last Modified:

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.
0
DataField
Asked:
DataField
  • 2
  • 2
  • 2
  • +1
1 Solution
 
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
 
ptjcbCommented:
You should look at the event log on the server (application) to see if there were any events that caused the shutdown.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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
 
ptjcbCommented:
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now