June 17, 2011 at 7:14 am
My database instance cannot be connected to, citing "Server is in script upgrade mode," after what appears to be an event early this morning where a service pack was installed. I do not have Windows Update set to install updates automatically, but nonetheless, I have this in my Application event logs from last night:
"Windows Installer installed an updated. Product Name: SQL Server 2008 RS Database Engine Shared. Product Version: 10.50.1600.1. Product Language: 1033. Update Name: GDR 1617 for SQL Server Database Services 2008 Core Shared (64-bit) (KB2494088). Installation success or error status: 0." - Source MsiInstaller
Sure enough, after this, I see the Windows halted my SQL Server Services. I've checked the KB article from MSFT and there's not much of an explanation, other than listing what files were affected by the update.
Anyone else experiencing similar issues?
June 17, 2011 at 7:20 am
coronaride (6/17/2011)
My database instance cannot be connected to, citing "Server is in script upgrade mode," after what appears to be an event early this morning where a service pack was installed. I do not have Windows Update set to install updates automatically, but nonetheless, I have this in my Application event logs from last night:"Windows Installer installed an updated. Product Name: SQL Server 2008 RS Database Engine Shared. Product Version: 10.50.1600.1. Product Language: 1033. Update Name: GDR 1617 for SQL Server Database Services 2008 Core Shared (64-bit) (KB2494088). Installation success or error status: 0." - Source MsiInstaller
Sure enough, after this, I see the Windows halted my SQL Server Services. I've checked the KB article from MSFT and there's not much of an explanation, other than listing what files were affected by the update.
Anyone else experiencing similar issues?
After patching an upgrade script is triggered on first startup.
Regular users are expected to see: "Server is in script upgrade mode" message until upgrade script ends.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 17, 2011 at 7:29 am
Ok, yeah, I might understand that. I'm more concerned about why this patch was installed when I specifically have Windows Update set to not automatically install. This is especially problematic in that it took my server offline.
June 17, 2011 at 7:34 am
coronaride (6/17/2011)
Ok, yeah, I might understand that. I'm more concerned about why this patch was installed when I specifically have Windows Update set to not automatically install. This is especially problematic in that it took my server offline.
Agreed - that's a good concern to have.
Any chance in hell a proactive sysadmin decided to install it manually or, an Altiris alike third party product just pushed the patch automatically to the server?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 17, 2011 at 7:39 am
Nope. Any other way that this could've been installed? This is a fairly new patch, according to MSFT.
June 17, 2011 at 7:47 am
coronaride (6/17/2011)
Nope. Any other way that this could've been installed? This is a fairly new patch, according to MSFT.
You stated "windows update" is not setup, how about "Microsoft update"?
http://update.microsoft.com/microsoftupdate/v6/about.aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 17, 2011 at 8:11 am
also, no.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply