SQL stopped because spid3

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chen - 30 Mar 2005 23:31 GMT

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

Reply to this Message

Mike Epprecht (SQL MVP) - 31 Mar 2005 14:03 GMT

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

> Hi,
>
[quoted text clipped - 8 lines]
> Regards,
> -Chen

Reply to this Message

Chen - 31 Mar 2005 15:13 GMT

Thanks!

> Hi
>
[quoted text clipped - 21 lines]
> > Regards,
> > -Chen

Reply to this Message

Geoff N. Hiten - 31 Mar 2005 15:20 GMT

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

> Hi,
>
[quoted text clipped - 10 lines]
> Regards,
> -Chen

Reply to this Message