August 11, 2008 at 8:53 pm
SQL Server crashed with the following error.
08/12/08 00:01:02 spid 99 Exception 0xc0000005 EXCEPTION_ACCESS_VIOLATION at 0x77FCCA14
Problem creating symptom dump file due to internal exception2008-08-12 00:01:02.93 spid99 Error: 0, Severity: 19, State: 0
Enterprise Manager was not accessible, nor were the dependent services able to connect.
Pls help on what could the possible reasons which could have caused this, and how can i go about investigating this. Is there any way I can prevent it in future..please advice..
August 11, 2008 at 9:57 pm
I would suggest you call Microsoft to go through the dump and help you determine what happened.
August 12, 2008 at 1:04 am
First thing MS will ask you is :
- What SP level are you on ? (sp4 is the current)
- did you apply any hotfixes ?
If you are not on sp4, they will suggest to upgrade to sp4.
So you may want to prepare that yourself and save $.
Prepare the upgrade, because you may also have to apply the hotfix at KB916287.
So what lever are you on ?
select @@version
--
select serverproperty('ProductVersion') as PVersion
, serverproperty('ProductLevel') as PLevel
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply