SQL Server Restarted Automatically

Question

SQL Server Restarted Automatically

Narine M

SSCrazy

Points: 2672
More actions
March 7, 2017 at 5:32 am

#335526

Hi All,
In our production server, suddenly the server got restarted .What will be the reason..Is there any other way to check it.
Error: sql server is not ready to accept new client connections.
Thanks in Advance
NM
March 8, 2017 at 1:24 am

This was removed by the editor as SPAM
March 8, 2017 at 10:25 pm

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246962 More actions · Answer 1

Narine M - Tuesday, March 7, 2017 5:32 AM
Hi All,
In our production server, suddenly the server got restarted .What will be the reason..Is there any other way to check it.
Error: sql server is not ready to accept new client connections.
Thanks in Advance
NM

Check the server's Event Log.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Narine M SSCrazy Points: 2672 More actions · Answer 2

Checked the event log also. But didnt find any related errors.

Sue_H SSC Guru Points: 90860 More actions · Answer 3

Narine M - Tuesday, March 7, 2017 7:44 AM
Checked the event log also. But didnt find any related errors.

Did you check the SQL Server error logs?

Sue

Bill Talada SSChampion Points: 11954 More actions · Answer 4

Many times when working on customer's hosts I've had windows restart messages popup with a timer! Sometimes they were hidden in the background and the timer counted down to just a few minutes before I noticed it in the task bar. Sometimes Microsoft has the dumbest default settings.

Narine M SSCrazy Points: 2672 More actions · Answer 5

Thanks for the reply, the system is restarted by Application user.