September 21, 2006 at 8:22 am
I system admins seem to like to just issue a hard shutdown of our SQL Server machines, which crashes SQL Server with the following errors:
2006-09-19 18:01:08.41 server SQL Server terminating because of system shutdown.
2006-09-19 18:01:27.60 spid3 LogEvent: Failed to report the current event. Operating system error = 1717(The interface is unknown.).
So here are my questions. Has anyone experienced a problem with this method of shutdown? Should I remind our sysadmins that SQL Server that it is best to first stopping the SQL Server services, and then perform a shutdown?
Gregory A. Larsen, MVP
September 21, 2006 at 9:19 am
Greg,
Stopping the server by using Shutdown button on the screen is not a Hard Shutdown which is pressing a button on the hardware. You can see an orderly shut down in the log issued by the Service Manager. I never have a second record from logEvent, but it may be a custom job trying to log event into the event log on SQL Server exit, but Event Log service probably would not accept any new records.
I too try to tell the server support to stop SQL Server before applying patches at least. I did not problems with the normal shutdown, but I am telling them just in case if during the patch application the server becomes unresponsive and they would have to press a hardware button which could lead to the problems.
Regards,Yelena Varsha
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply