SQL Server 2008R2 - build - 10.50.1734.0
I'm having a real issue with our SQL 2008 R2 server. The MSSQLSERVER service keeps crashing on our Windows 2008 R2 server. I have set the service to restart after a failure, so the service comes back up after a few seconds. However, it tends
to happen for a period of a few hours, between 10AM - 1PM every working day - so I will receive about 50 crashes and restarts.
I have pasted the error message from the Windows logs below. All that the SQL server logs tell me is the following - " The MSSQLSERVER service terminated unexpectedly "
I have applied the latest cumulutive hotfix 3, but this didn't make the issue go away. It was this fix/file > SQLServer2008R2_RTM_CU3_2261464_10_50_1734_x64
(I see that there are other CU3 fixes for 2008R2, but I haven't applied them as I didn't know if they applied to my system or not, is this ok?) http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2261464&kbln=en-us#step2
I don't know what further information I can provide. Is there anything else I can do to interrogate the issue, 3rd party loging products?
Does anyone have any idea what is going on?
Event ID: 1000 - Application error
Faulting application name: sqlservr.exe
View Complete Post