Saturday, February 25, 2012

c0000005 EXCEPTION_ACCESS_VIOLATION after stopping/starting servi

On a nightly basis, SQL services are stopped to perform backups.
Afterwards the services are started.
This has been working for years.
Middle of last week, SQL has been failing to start.
SqlDumpExceptionHandler: Process 4844 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
It requires a REBOOT to bring SQL back up.
No maintenace has been applied, Windows or SQL Server.
Win2K Server Standard Edition SP4
SQL Server SP4First question:
Have you seen this page yet? http://support.microsoft.com/?kbid=814572
Second question:
Why do you stop/start SQL to run backups? You can run "hot" backups
using the BACKUP command or a maintenance plan, then backup those
backup files.|||Found the problem.
It's the anti-virus software McAfee.
It upgraded itself the other week.
I've gotten around the problem by shutting down the McAfee services before
restarting the MS SQL services.
Right or wrong, it works.
"Mark Kuntz" wrote:

> On a nightly basis, SQL services are stopped to perform backups.
> Afterwards the services are started.
> This has been working for years.
> Middle of last week, SQL has been failing to start.
> SqlDumpExceptionHandler: Process 4844 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> It requires a REBOOT to bring SQL back up.
> No maintenace has been applied, Windows or SQL Server.
> Win2K Server Standard Edition SP4
> SQL Server SP4

No comments:

Post a Comment