RE: SQL stopped because spid3

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Thanks!

"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,
> > -Chen
.



Relevant Pages

  • anyone can give solution for this problem
    ... SQL Server is terminating this ... BEGIN STACK DUMP: ... Access Violation occurred reading address ...
    (microsoft.public.sqlserver.mseq)
  • Re: SQL 2005 Upgrade Error Password
    ... Client]Signing sps ... ... meet Windows policy requirements because it is too short. ... Client]Unspecified error occurred on SQL Server. ... SQL Server is terminating this process. ...
    (microsoft.public.sqlserver.setup)
  • RE: SQL server Failed Assertion - corrupting tables
    ... "Martin" wrote: ... > The SQL server seems to be dropping all connections to the databases, ... > terminating this process. ...
    (microsoft.public.sqlserver.server)
  • Re: ConnectionCheckForData, General network error
    ... Process 53 generated fatal exception c0000005 ... SQL Server is terminating this process. ... Process 53 generated an access violation. ...
    (microsoft.public.sqlserver.programming)
  • SQL server Failed Assertion - corrupting tables
    ... The SQL server seems to be dropping all connections to the databases, ... SQL Server is terminating this process. ... Process 1 generated an access violation. ...
    (microsoft.public.sqlserver.server)