Hi,

In out production clustering server, installed SQL Server 2000 and sp3
applied. Around 2:00 a.m. this morning, during the database loading, the SQL
auto stopped by self. The errorlog shows spid3 SQL Server is terminating due
to 'stop' request from Service Control Manager. I checked spid3 that is
background process LAZY WRITER.

Can someone tell, why it auto stopped SQL service?

Regards,
-Chen

Hi

It did not. "SQL Server is terminating due to 'stop' request from Service
Control Manager" indicates that either the Cluster Software or a Stop from
control panel told SQL server to stop. SPID 3 just logs the message that it
has been told to stop.

If it was the cluster software, it means that it did not believe that that
node was still operating normally.

Regards
Mike


"Chen" wrote:

Thanks!

"Mike Epprecht (SQL MVP)" wrote:

Check your application and system event logs on both nodes to see why it
shut down without failing over. It sounds like it was told to shut down by
a control event or a user.

Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator


"Chen" <Chen (AT) discussions (DOT) microsoft.com> wrote