luyan
asked on
EXCEPTION_ACCESS_VIOLATION
In SQLDump log file, I got following error. What's wrong?
* BEGIN STACK DUMP:
* Exception Address = 004314FA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 8C478C7E
...
* BEGIN STACK DUMP:
* Exception Address = 004314FA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 8C478C7E
...
What version of SQL Server? What service pack?
ASKER
SQL Server 2000 with service pack 4.
Thanks!
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You think it's a bug of SQL Server 2000? Sometimes it didn't happen, sometimes it happend. Thanks!
There is another possibility: do you have antivirus software running on the server?
ASKER
We have Symantec AntiVirus running on the server.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Can you tell me how to configure the Antivirus to SKIP all the .mdf, .ndf, ldf files in the data folders of the databases? I want to take a try. Thanks!
Well, I have no idea as I don't have Symantec Antivirus.
For a check, you might simply disable it completely for a certain time.
say the dump appears every 2-3 times per day, if disabled your sql runs for 2 days, you can assume that it was the issue.
I guess you will find some options to put exclusions or rules or something like that...
For a check, you might simply disable it completely for a certain time.
say the dump appears every 2-3 times per day, if disabled your sql runs for 2 days, you can assume that it was the issue.
I guess you will find some options to put exclusions or rules or something like that...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks angelIII! I will try it.
ASKER
The problem was still there after the configuration on Symantec Antivirus with SKIP all .mdf, .ndf, .ldf files. Any other good ideas to solve the problem? Thanks!
no, I have no other ideas.
ASKER
Thanks AngelII!
Does anyone see the error "EXCEPTION_ACCESS_VIOLATIO N" before? How to fix it? Thanks!
Does anyone see the error "EXCEPTION_ACCESS_VIOLATIO
ASKER
All set now. It's problem of hardware. Thanks for all your help!
ASKER