My MSSQL 2008 service keep stopping don't know why. I took the habit to just restart the service, but it's getting really annoying.
Does anyone has a clue on why it keeps shutting down ?
Sql server 2008, logged as local.
Here are 4 SQLdump from today.
found this in my event viewer :
SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
Error when I tried to install MSSQL 2008 SP3 (x64)
The version of the instance of SQL Server Shared Component does not match the expected version of the update to SQL Server. The version of the SQL Server product installed is 10.50.1600.1 and the version of SQL Server expected is 10.0.1600.22.
SELECT @@VERSION res
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.2 (Build 9200: )