November 12, 2013 at 10:56 am
I noticed there was a SQL server restart happened last night. It was shut down then start up in 2 minutes.
I tried to figure out if it is an automatic restart or someone manually restart the server.
But I have no clue. It is running fine now.
Attached is a SQL server log, and I cannot find any information in the window event log.
What does the error really mean, how can I figure out is this a manual restart or system automatic start due to windows os error?
Thanks
November 12, 2013 at 12:41 pm
The SQL Log clearly shows SQL Service has been stopped because of Server Shutdown. To be able to identify what triggered this, investigate Windows logs(Application/System/Setup/Security) from Event viewer(Not just the Application logs) from around 11/09/2013 9 PM to 10.03 PM for any clues.
November 13, 2013 at 8:51 am
So overnight on a Tuesday. First thing I'd check would be was this due to an automatic reboot triggered by Windows Update?
November 13, 2013 at 10:33 am
Yes, you are right, it is a windows update.
But how it happens I don't think we set up to do the automatically update for servers.
We do it manually.
November 15, 2013 at 4:02 am
November 15, 2013 at 5:40 am
Windows updates are applied by either the Windows Update service and for SQL Server 2005 and beyond, SQL Server SPs and patches are handled by Windows Update.
If I'm not mistaken, the updates can be pulled from either the MS site or from a WSUS server. As a local administrator on the server, you can configure how Windows downloads updates, but so can the domain administrator. I'd check with them to make sure there wasn't a change in the Active Directory regarding updates. Not that domain admins would ever make a change without notifying the DBA. 😉
November 15, 2013 at 6:40 am
Also if the server is a virtual you should check into how the physical server hosting them is updated.
The updates could also be distributed via some other means - most commonly SCCM rather than using WUA so you really need to check with your Windows admins as to why these are applied automatically.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply