January 8, 2018 at 12:13 am
In our environment, SQL server 2012 is automatically restarted, what will be issue??? Nothing related information is found in Event Viewer also.
Message
The current event was not reported to the Windows Events log. Operating system error = (null). You may need to clear the Windows Events log if it is full.
SQL Server shutdown has been initiated
Message
SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
January 8, 2018 at 2:19 am
This was removed by the editor as SPAM
January 8, 2018 at 10:41 am
Would you are to share a more complete error log? Was there memory dump in the log? OS and SQL version info, processor type, memory size?
January 10, 2018 at 3:28 am
NO memory dump over there.
Error Log:
Message
This instance of SQL Server has been using a process ID of 1448 since 12/14/2017 3:55:38 AM (local) 12/13/2017 10:25:38 PM (UTC). This is an informational message only; no user action is required.
Message
SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
Service Broker manager has shut down.
Message
Error: 17054, Severity: 16, State: 1.
Message
The current event was not reported to the Windows Events log. Operating system error = (null). You may need to clear the Windows Events log if it is full.
Message
.NET Framework runtime has been stopped.
Message
SQL Server shutdown has been initiated
Message
SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
January 10, 2018 at 3:54 am
Narine M - Wednesday, January 10, 2018 3:28 AMSQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
.
That suggests that Windows is booting and SQL shutting down is for the server shutdown.
Are you seeing the server reboot, or are you certain it's just SQL restarting?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 10, 2018 at 9:27 am
Could it be automatic Windows Update that is causing system reboot?
January 10, 2018 at 10:33 am
It's possible.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 10, 2018 at 11:24 pm
This was removed by the editor as SPAM
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply