SQL Server Suddenly Stop

Question

question

Leo asked Apr 10, '10

SQL Server Suddenly Stop

Hi everyone,

I got a call from one of my developer this morning saying that one of our production server is down, when I checked on the server, SQL Server is stopped. When I check the time and date when that is occur, it was last night. I go through all the normal procedure - Windows Event Viewer\system,security, SQL Logs, etc... Nothing strange expect the following error in SQL Logs, it looks like SQL Server Service is crashed by some reason. Any Idea ??

Here is the message in SQL Log ...

Date,Source,Severity,Message 04/09/2010 19:42:57,Server,Unknown,The SQL Server Network Interface library successfully deregistered the Service Principal Name (SPN) [ MSSQLSvc/xxxxservernamexxx:1433 ] for the SQL Server service. 04/09/2010 19:42:57,Server,Unknown,The SQL Server Network Interface library successfully deregistered the Service Principal Name (SPN) [ MSSQLSvc/xxxxservernamexxxx ] for the SQL Server service. 04/09/2010 19:42:57,spid9s,Unknown,SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required. 04/09/2010 19:42:57,Server,Unknown,External dump process return code 0x20000001.External dump process returned no errors. 04/09/2010 19:42:54,Server,Unknown,Stack Signature for the dump is 0x00000001CFD4E29E 04/09/2010 19:42:54,Server,Unknown,0000000077D6B71A Module(kernel32+000000000002B71A) 04/09/2010 19:42:54,Server,Unknown,0000000078133894 Module(MSVCR80+0000000000003894) 04/09/2010 19:42:54,Server,Unknown,00000000781337DE Module(MSVCR80+00000000000037DE) 04/09/2010 19:42:54,Server,Unknown,00000000781337B7 Module(MSVCR80+00000000000037B7) 04/09/2010 19:42:54,Server,Unknown,0000000077D67355 Module(kernel32+0000000000027355) 04/09/2010 19:42:54,Server,Unknown,0000000077EE964E Module(ntdll+000000000002964E) 04/09/2010 19:42:54,Server,Unknown,000007FF76410462 Module(winhttp+0000000000060462) 04/09/2010 19:42:54,Server,Unknown,000007FF763B8FF7 Module(winhttp+0000000000008FF7) 04/09/2010 19:42:54,Server,Unknown,000007FF763C5AE9 Module(winhttp+0000000000015AE9) 04/09/2010 19:42:54,Server,Unknown,000007FF763D2ECD Module(winhttp+0000000000022ECD) 04/09/2010 19:42:54,Server,Unknown,0000000077EF31ED Module(ntdll+00000000000331ED) 04/09/2010 19:42:54,Server,Unknown,0000000077EE60A7 Module(ntdll+00000000000260A7) 04/09/2010 19:42:54,Server,Unknown,0000000077EE459D Module(ntdll+000000000002459D) 04/09/2010 19:42:54,Server,Unknown,0000000077EE6593 Module(ntdll+0000000000026593) 04/09/2010 19:42:54,Server,Unknown,0000000077DBC4FF Module(kernel32+000000000007C4FF) 04/09/2010 19:42:54,Server,Unknown,0000000077DC0053 Module(kernel32+0000000000080053) 04/09/2010 19:42:54,Server,Unknown,000000000274891C Module(sqlservr+000000000174891C) 04/09/2010 19:42:54,Server,Unknown,0000000002962459 Module(sqlservr+0000000001962459) 04/09/2010 19:42:54,Server,Unknown,0000000002961DB6 Module(sqlservr+0000000001961DB6) 04/09/2010 19:42:54,Server,Unknown,0000000002954C3D Module(sqlservr+0000000001954C3D) 04/09/2010 19:42:54,Server,Unknown,0000000077D67DED Module(kernel32+0000000000027DED) 04/09/2010 19:42:54,Server,Unknown,* Short Stack Dump 04/09/2010 19:42:54,Server,Unknown,* ------------------------------------------------------------------------------- 04/09/2010 19:42:54,Server,Unknown,* ********************************************* 04/09/2010 19:42:54,Server,Unknown,* Rip: 0000000077D67DED: C3000000C8C48148 15FF984B8D49D233 8679E990FFFD967F 9090909090900000 834853C08B909090 0C0C7A158B4830EC 04/09/2010 19:42:54,Server,Unknown,* R15: 0000000000000001: 04/09/2010 19:42:54,Server,Unknown,* R14: 00000000344AE940: 0068005F00780065 006C0064006E0061 00780065005F0065 0074007000650063 0063006E00650020 0074006E0075006F 04/09/2010 19:42:54,Server,Unknown,* R13: 0000000000000000: 04/09/2010 19:42:54,Server,Unknown,* R12: 000000000000003F: 04/09/2010 19:42:54,Server,Unknown,* R11: 00000000344ADA70: 00000000109E7780 00000000344ACEB0 0000000000000000 00000000344AD1F8 0000000000000001 00000000344AD210 04/09/2010 19:42:54,Server,Unknown,* R10: 0000000000000000: 04/09/2010 19:42:54,Server,Unknown,* R9: 0000000000000000: 04/09/2010 19:42:54,Server,Unknown,* R8: 0000000000000000: 04/09/2010 19:42:54,Server,Unknown,* Rdi: 0000000000000000: 04/09/2010 19:42:54,Server,Unknown,* Rsi: 00000000344AD530: 00000000109DB460 0000000077EFFC48 FFFFFFFFFFFFFFFF 000000035ECE6ED0 0000000000000000 000000036993E1A0 04/09/2010 19:42:54,Server,Unknown,* Rbp: 00000000344AEBC0: 0000000000000004 0000000200000001 0000000077D8B84B 0000000000000000 00000000344AEC58 00000000344AEFB0 04/09/2010 19:42:54,Server,Unknown,* Rsp: 00000000344AD280: 000000000000003F 0000000000000000 00000000344AD530 0000000000000000 00000000000042AC 0000000000000000 04/09/2010 19:42:54,Server,Unknown,* Rbx: 0000000000000000: 04/09/2010 19:42:54,Server,Unknown,* Rdx: 0000000000000000: 04/09/2010 19:42:54,Server,Unknown,* Rcx: 00000000344ACDA0: 00000000109E7780 00000000344ACEB0 0000000000000000 00000000344AD1F8 0000000000000001 00000000344AD210 04/09/2010 19:42:54,Server,Unknown,* Rax: 00000000344AD278: 0000000077D67DED 000000000000003F 0000000000000000 00000000344AD530 0000000000000000 00000000000042AC 04/09/2010 19:42:54,Server,Unknown,* EFlags: 0000000000000202: 04/09/2010 19:42:54,Server,Unknown,* SegSs: 000000000000002B: 04/09/2010 19:42:54,Server,Unknown,* SegGs: 000000000000002B: 04/09/2010 19:42:54,Server,Unknown,* SegFs: 0000000000000053: 04/09/2010 19:42:54,Server,Unknown,* SegEs: 000000000000002B: 04/09/2010 19:42:54,Server,Unknown,* SegDs: 000000000000002B: 04/09/2010 19:42:54,Server,Unknown,* SegCs: 0000000000000033: 04/09/2010 19:42:54,Server,Unknown,* MxCsr: 0000000000001F80: 04/09/2010 19:42:54,Server,Unknown,* ContextFlags: 000000000010000F: 04/09/2010 19:42:54,Server,Unknown,* P6Home: 00000000344AD210: 0000000000000000 0000000000000000 0000000000000000 0000000000000000 000007FF00000030 0000000000000000 04/09/2010 19:42:54,Server,Unknown,* P5Home: 0000000000000001: 04/09/2010 19:42:54,Server,Unknown,* P4Home: 00000000344AD1F8: 00000000021A0092 00000000109E7780 000007FFFFF71568 0000000000000000 0000000000000000 0000000000000000 04/09/2010 19:42:54,Server,Unknown,* P3Home: 0000000000000000: 04/09/2010 19:42:54,Server,Unknown,* P2Home: 00000000344ACEB0: 0000002B344ABD38 0000FFFF00001F80 0000000000000000 0000000000000000 0000000000000000 0000000000000000 04/09/2010 19:42:54,Server,Unknown,* P1Home: 00000000109E7780: 00000000002BD190 004D005C003A0045 006F007200630069 00740066006F0073 004C005100530020 0072006500530020 04/09/2010 19:42:54,Server,Unknown,* 04/09/2010 19:42:54,Server,Unknown,* dbghelp 0000000036070000 00000000361CDFFF 0015e000 04/09/2010 19:42:54,Server,Unknown,* winhttp 000007FF763B0000 000007FF76433FFF 00084000 04/09/2010 19:42:54,Server,Unknown,* msxmlsql 0000000078800000 0000000078950FFF 00151000 04/09/2010 19:42:54,Server,Unknown,* mlang 000007FF7A4C0000 000007FF7A56EFFF 000af000 04/09/2010 19:42:54,Server,Unknown,* SXS 000007FF7CC60000 000007FF7CE46FFF 001e7000 04/09/2010 19:42:54,Server,Unknown,* odsole70 0000000033380000 0000000033396FFF 00017000 04/09/2010 19:42:54,Server,Unknown,* instapi 0000000048060000 000000004806CFFF 0000d000 04/09/2010 19:42:54,Server,Unknown,* sqlvdi 0000000034510000 000000003453AFFF 0002b000 04/09/2010 19:42:54,Server,Unknown,* MPR 000007FF772D0000 000007FF772F0FFF 00021000 04/09/2010 19:42:54,Server,Unknown,* xp_sqlbackup 0000000012A60000 0000000012ADAFFF 0007b000 04/09/2010 19:42:54,Server,Unknown,* xplog70 0000000012410000 0000000012411FFF 00002000 04/09/2010 19:42:54,Server,Unknown,* xplog70 0000000034730000 000000003473FFFF 00010000 04/09/2010 19:42:54,Server,Unknown,* xpsqlbot 000000004A7C0000 000000004A7C7FFF 00008000 04/09/2010 19:42:54,Server,Unknown,* xpstar 0000000004F00000 0000000004F24FFF 00025000 04/09/2010 19:42:54,Server,Unknown,* ATL80 000000007C630000 000000007C64EFFF 0001f000 04/09/2010 19:42:54,Server,Unknown,* SQLSCM 0000000053AD0000 0000000053ADBFFF 0000c000 04/09/2010 19:42:54,Server,Unknown,* xpstar 0000000053C30000 0000000053CB7FFF 00088000 04/09/2010 19:42:54,Server,Unknown,* SQLNCLIR10 0000000035000000 0000000035036FFF 00037000 04/09/2010 19:42:54,Server,Unknown,* sqlncli10 00000000337A0000 0000000033AA6FFF 00307000 04/09/2010 19:42:54,Server,Unknown,* COMRes 000007FF7EAF0000 000007FF7EBB5FFF 000c6000 04/09/2010 19:42:54,Server,Unknown,* CLBCatQ 000007FF7EA10000 000007FF7EAEDFFF 000de000 04/09/2010 19:42:54,Server,Unknown,* xpsp2res 0000000011C50000 0000000011F16FFF 002c7000 04/09/2010 19:42:54,Server,Unknown,* rasadhlp 000007FF7EA00000 000007FF7EA06FFF 00007000 04/09/2010 19:42:54,Server,Unknown,* winrnr 000007FF7E9F0000 000007FF7E9FAFFF 0000b000 04/09/2010 19:42:54,Server,Unknown,* DNSAPI 000007FF7E8F0000 000007FF7E93DFFF 0004e000 04/09/2010 19:42:54,Server,Unknown,* ntdsapi 000007FF7DCB0000 000007FF7DCD3FFF 00024000 04/09/2010 19:42:54,Server,Unknown,* SAMLIB 000007FF77150000 000007FF77165FFF 00016000 04/09/2010 19:42:54,Server,Unknown,* WLDAP32 000007FF7E950000 000007FF7E9B5FFF 00066000 04/09/2010 19:42:54,Server,Unknown,* NTMARTA 000007FF7E4C0000 000007FF7E4FBFFF 0003c000 04/09/2010 19:42:54,Server,Unknown,* wshtcpip 000007FF77170000 000007FF7717AFFF 0000b000 04/09/2010 19:42:54,Server,Unknown,* hnetcfg 000007FF6D200000 000007FF6D292FFF 00093000 04/09/2010 19:42:54,Server,Unknown,* mswsock 000007FF771B0000 000007FF7722CFFF 0007d000 04/09/2010 19:42:54,Server,Unknown,* dssenh 0000000068100000 000000006813EFFF 0003f000 04/09/2010 19:42:54,Server,Unknown,* imagehlp 000007FF7E470000 000007FF7E482FFF 00013000 04/09/2010 19:42:54,Server,Unknown,* WINTRUST 000007FF7E3E0000 000007FF7E42DFFF 0004e000 04/09/2010 19:42:54,Server,Unknown,* dbghelp 000000000FCC0000 000000000FE1DFFF 0015e000 04/09/2010 19:42:54,Server,Unknown,* MSFTE 0000000049980000 0000000049D2DFFF 003ae000 04/09/2010 19:42:54,Server,Unknown,* ftimport 0000000060000000 0000000060024FFF 00025000 04/09/2010 19:42:54,Server,Unknown,* security 000007FF77530000 000007FF77534FFF 00005000 04/09/2010 19:42:54,Server,Unknown,* schannel 000007FF7DD50000 000007FF7DD91FFF 00042000 04/09/2010 19:42:54,Server,Unknown,* kerberos 000007FF77410000 000007FF774C4FFF 000b5000 04/09/2010 19:42:54,Server,Unknown,* iphlpapi 000007FF57040000 000007FF57070FFF 00031000 04/09/2010 19:42:54,Server,Unknown,* WS2HELP 000007FF77140000 000007FF7714BFFF 0000c000 04/09/2010 19:42:54,Server,Unknown,* WS2_32 000007FF77310000 000007FF7733FFFF 00030000 04/09/2010 19:42:54,Server,Unknown,* cryptdll 000007FF7DC90000 000007FF7DC9EFFF 0000f000 04/09/2010 19:42:54,Server,Unknown,* msv1_0 000007FF7E500000 000007FF7E544FFF 00045000 04/09/2010 19:42:54,Server,Unknown,* MSCOREE 000006427EE50000 000006427EEB5FFF 00066000 04/09/2010 19:42:54,Server,Unknown,* AUTHZ 000007FF7E490000 000007FF7E4BDFFF 0002e000 04/09/2010 19:42:54,Server,Unknown,* rsaenh 0000000068000000 000000006804BFFF 0004c000 04/09/2010 19:42:54,Server,Unknown,* sqlevn70 000000004F610000 000000004F80CFFF 001fd000 04/09/2010 19:42:54,Server,Unknown,* instapi10 0000000000FF0000 0000000000FFCFFF 0000d000 04/09/2010 19:42:54,Server,Unknown,* psapi 000007FF7E380000 000007FF7E38FFFF 00010000 04/09/2010 19:42:54,Server,Unknown,* odbcint 000007FF63DC0000 000007FF63DD7FFF 00018000 04/09/2010 19:42:54,Server,Unknown,* comctl32 000007FF7F000000 000007FF7F186FFF 00187000 04/09/2010 19:42:54,Server,Unknown,* IMM32 000007FF7D500000 000007FF7D538FFF 00039000 04/09/2010 19:42:54,Server,Unknown,* BatchParser 00000000520C0000 00000000520EBFFF 0002c000 04/09/2010 19:42:54,Server,Unknown,* NETAPI32 000007FF77370000 000007FF77408FFF 00099000 04/09/2010 19:42:54,Server,Unknown,* opends60 00000000333E0000 00000000333E7FFF 00008000 04/09/2010 19:42:54,Server,Unknown,* WINMM 000007FF7E240000 000007FF7E28FFFF 00050000 04/09/2010 19:42:54,Server,Unknown,* USERENV 000007FF7C680000 000007FF7C789FFF 0010a000 04/09/2010 19:42:54,Server,Unknown,* MSASN1 000007FF7D340000 000007FF7D36BFFF 0002c000 04/09/2010 19:42:54,Server,Unknown,* CRYPT32 000007FF7D370000 000007FF7D4CEFFF 0015f000 04/09/2010 19:42:54,Server,Unknown,* VERSION 000007FF7FBF0000 000007FF7FBFAFFF 0000b000 04/09/2010 19:42:54,Server,Unknown,* odbcbcp 000007FF63EE0000 000007FF63EE7FFF 00008000 04/09/2010 19:42:54,Server,Unknown,* ODBC32 000007FF63F00000 000007FF63F66FFF 00067000 04/09/2010 19:42:54,Server,Unknown,* OLEAUT32 000007FF7EBC0000 000007FF7ECD5FFF 00116000 04/09/2010 19:42:54,Server,Unknown,* ole32 000007FF57140000 000007FF573C4FFF 00285000 04/09/2010 19:42:54,Server,Unknown,* SHELL32 000007FF7F190000 000007FF7FB9AFFF 00a0b000 04/09/2010 19:42:54,Server,Unknown,* COMCTL32 000007FF76200000 000007FF762EEFFF 000ef000 04/09/2010 19:42:54,Server,Unknown,* comdlg32 000007FF7D540000 000007FF7D5B6FFF 00077000 04/09/2010 19:42:54,Server,Unknown,* USER32 0000000077C20000 0000000077D2BFFF 0010c000 04/09/2010 19:42:54,Server,Unknown,* GDI32 000007FF7FC90000 000007FF7FD2BFFF 0009c000 04/09/2010 19:42:54,Server,Unknown,* SHLWAPI 000007FF7EF60000 000007FF7EFFAFFF 0009b000 04/09/2010 19:42:54,Server,Unknown,* pdh 000007FF5B170000 000007FF5B200FFF 00091000 04/09/2010 19:42:54,Server,Unknown,* sqlos 00000000344D0000 00000000344D6FFF 00007000 04/09/2010 19:42:54,Server,Unknown,* Secur32 000007FF7E9C0000 000007FF7E9E1FFF 00022000 04/09/2010 19:42:54,Server,Unknown,* RPCRT4 000007FF7FD30000 000007FF7FEC8FFF 00199000 04/09/2010 19:42:54,Server,Unknown,* ADVAPI32 000007FF7FEE0000 000007FF7FFE5FFF 00106000 04/09/2010 19:42:54,Server,Unknown,* MSVCP80 000000007C420000 000000007C528FFF 00109000 04/09/2010 19:42:54,Server,Unknown,* msvcrt 000007FF7FC00000 000007FF7FC85FFF 00086000 04/09/2010 19:42:54,Server,Unknown,* MSVCR80 0000000078130000 00000000781F8FFF 000c9000 04/09/2010 19:42:54,Server,Unknown,* kernel32 0000000077D40000 0000000077EB2FFF 00173000 04/09/2010 19:42:54,Server,Unknown,* ntdll 0000000077EC0000 0000000077FFAFFF 0013b000 04/09/2010 19:42:54,Server,Unknown,* sqlservr 0000000001000000 0000000004813FFF 03814000 04/09/2010 19:42:54,Server,Unknown,* MODULE BASE END SIZE 04/09/2010 19:42:54,Server,Unknown,* 04/09/2010 19:42:54,Server,Unknown,* 04/09/2010 19:42:54,Server,Unknown,* ex_handle_except encountered exception C0000005 - Server terminating 04/09/2010 19:42:54,Server,Unknown,* 04/09/2010 19:42:54,Server,Unknown,* 04/09/10 19:42:54 spid 3268 04/09/2010 19:42:54,Server,Unknown,* BEGIN STACK DUMP: 04/09/2010 19:42:54,Server,Unknown,* 04/09/2010 19:42:54,Server,Unknown,* ********************************************* 04/09/2010 19:42:54,Server,Unknown,**Stack Dump being sent to E:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\LOG\SQLDump0001.txt 04/09/2010 19:42:54,Server,Unknown,*Dump thread - spid = 0 EC = 0x0000000000000000 04/09/2010 19:42:54,Server,Unknown,Using 'dbghelp.dll' version '4.0.5' 04/09/2010 19:42:54,Server,Unknown,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). 04/09/2010 19:42:54,Server,Unknown,Error: 17311 Severity: 16 State: 1.

Can you tell me why that happened? Thanks.

sql-server-2008 sql

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-04-10T07:15:28Z

Fatherjack answered Apr 10, '10

From a search for the error I found this link http://support.microsoft.com/kb/919392 that then links to a page on how to read the SQL error log http://msdn.microsoft.com/en-us/library/ms187885.aspx. Have you looked in the SQL error log as your details recommend? I have seen some links pointing to HDD problems, may be worth running a chkdsk? Was there a restart of the whole server? Have you configured any traces or startup flags previously?

(10 mins later)
sorry, just re-reading this and you have obviously looked at the log (I'm blaming too much PS3 last night and lack of coffee this morning). The other points still stand though and also what Matt has added - setting SQL to autostart may be worth a try. It might be things on the box just got started in the wrong order and failed to recover.

6

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield ♦♦ commented · Apr 10, 2010 at 07:20 AM

+1 - it may also be worth considering setting sql server to auto restart...

0 ·

Matt Whitfield ♦♦ commented · Apr 10, 2010 at 08:52 AM

PS - Congrats on the 4k mate :)

0 ·

Fatherjack ♦♦ commented · Apr 10, 2010 at 09:12 AM

@Matt - thanks. I started out in Jan hoping to get to 1000 by Dec!

0 ·

DaniSQL commented · Apr 10, 2010 at 10:17 AM

@FatherJack...you are well on your way brother!

0 ·

Fatherjack ♦♦ commented · Apr 10, 2010 at 10:36 AM

@DaniSQL. Not on my way - already 4x ! Having to re-estimate my goal. 12k seems current prediction ... we shall see.

0 ·

Show more comments

Answer 2 · 2010-05-25T23:56:04Z

Vinicio Aizpurua answered May 25, '10

Do you have R2?

Read this: http://support.microsoft.com/kb/979779

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2010-10-19T13:16:39Z

creddy answered Oct 19, '10

hey Leo, Pls check out this link http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/ea05a4e1-dfea-4293-ac45-85a9ea949832 It might work for you.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question