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
[quoted text, click to view] "Chen" wrote:
> 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,
Thanks!
[quoted text, click to view] "Mike Epprecht (SQL MVP)" wrote:
> 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:
>
> > 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,
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
[quoted text, click to view] "Chen" <Chen@discussions.microsoft.com> wrote in message
news:81ADDFEB-DF72-4F67-BD51-AB0E0E2863A8@microsoft.com...
> 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
Don't see what you're looking for? Try a search.
