Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Tuesday, August 7, 2018 7:19 AM
Hi,
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
I found that sql server 2008 R2 was shut down suddenly today and could not find those details in error log. I was able to find in event log with event id 19019 and user as N/A. Not sure how the server got restarted. This server is not a clustered instance.
Log Name: Application
Source: MSSQLSERVER
Date: 8/6/2018 11:11:41 PM
Event ID: 19019
Task Category: Server
Level: Error
Keywords: Classic
User: N/A
Computer: XXXXXXXXXX
Description:
Can anyone explain the root cause of sudden shutdown?
Thanks,
Tuesday, August 7, 2018 7:23 AM | 1 vote
What does errorlog last few lines say in
sp_readerrorlog 1
What does the event viewer say. Do you see any other message part from one you posted
Cheers,
Shashank
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it
Tuesday, August 7, 2018 7:42 AM
Hi
Tuesday, August 7, 2018 7:48 AM
Read my response again I am asking last few lines, that would have information as to why SQL Server was shutting down. Or please post complete output of sp_readerrorlog 1 on shared drive for analysis and then post the link here
Cheers,
Shashank
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it
Tuesday, August 7, 2018 9:53 AM | 1 vote
Hi,
Since you are using SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64). First of all, I would suggest you to upgrade your SQL Server to SP3.
https://www.microsoft.com/en-us/download/details.aspx?id=44271
Then as you said that you could not find details in error log. Could you please share us your error log if possible? So that we can make some analysis.
Thanks,
Xi Jin.
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
Tuesday, August 7, 2018 10:30 AM | 1 vote
There's nothing in that image you posted that show the shutdown. As an aside, it seems you had a very long recovery (startup time), possibly for one or more of your databases and also possibly the DTC service (distributed transactions) was involved somehow.
Tibor Karaszi, SQL Server MVP (Web Blog)
Wednesday, August 8, 2018 7:49 AM | 1 vote
Had offline chat with TejaReddy he mailed me the screenshots.
It is quite clear that SQL Server is terminating unexpectedly. This may be due to bug in SQL Server.
Tejareddy please apply SQl Server 2008 R2 SP3 and report back if you still see such unexpected termination. We can hardly do anything for SQl Server unexpected termination. If that does not fixes it you might have to raise case with MS.
Please also check if you are using TP database provider in linked servers, that can also cause unexpected termination.
Cheers,
Shashank
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it