SQL Agent Stops

Hallo

I`m using Windows 2000 Server Standard.SQL 2000 SP3a.

While Deleting and rebuilding Indexes, the following errors occured....

17310 :
 SqlDumpExceptionHand
ler: Process 2888 generated fatal exception c0000005
 EXCEPTION_ACCESS_VIO
LATION. SQL Server is terminating this process.

17311 :
SQL Server is aborting. Fatal exception c0000005 caught.

After that SQL Agent stopped. I stared it again and everthing was ok.

Bye

Hi,

Did you checked if any backups were running during re-indexing database. It
is possible that when you stoped the SQL Agent, all opened connections were
closed and then there were free unlocked indexes to re-index

Check in the EM -> SQL Agent --> jobs for failures

Andreas

"DanielK." wrote:

> Hallo
>
> I`m using Windows 2000 Server Standard.SQL 2000 SP3a.
>
> While Deleting and rebuilding Indexes, the following errors occured....
>
> 17310 :
>  SqlDumpExceptionHand
ler: Process 2888 generated fatal exception c0000005
>  EXCEPTION_ACCESS_VIO
LATION. SQL Server is terminating this process.
>
> 17311 :
> SQL Server is aborting. Fatal exception c0000005 caught.
>
> After that SQL Agent stopped. I stared it again and everthing was ok.
>
> Bye

Hello

No, there was only a TRN backup running. The SQL service stopped unexpectedl
y.


"Andreas Mavrogenis" wrote:

> Hi,
>
> Did you checked if any backups were running during re-indexing database. I
t
> is possible that when you stoped the SQL Agent, all opened connections wer
e
> closed and then there were free unlocked indexes to re-index
>
> Check in the EM -> SQL Agent --> jobs for failures
>
> Andreas
>
> "DanielK." wrote:
> 

Hi,

Check the Event Viewer of your machine and point out the specific error. It
probably tell you more about.
Also check SQL Server logs to trace the unexpected stop

Check if the TRN backup was started at the time you did the re-indexind.
Andreas

"DanielK." wrote:

> Hello
>
> No, there was only a TRN backup running. The SQL service stopped unexpecte
dly.
>
>
> "Andreas Mavrogenis" wrote:
>