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: 246992 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

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

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.