sql server 2012 auto patching? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Other SQL Server 2012 Topics

sql server 2012 auto patching?

Author

Topic

zhuang
Starting Member

6 Posts

Posted - 2014-05-14 : 11:53:19

Hi,

Has sql server 2012 got auto patching features?

I am new to sql server, installed sqlserver 2012 on 17th March 2014. Today, I find out from the log that the server has been patched at least twice in the early morning. This VM should only be used by me; well in theory.

The current version is:
SQL Server 2012 Service Pack 1 11.00.3000.00

But I think, the installed version is:
SQL Server 2012 RTM 11.00.2100.60

Thank you for any comment and help.

Regards,

Zhuang
The following is the part of the log file:

===============================================================
03/20/2014 05:11:49,spid8s,Unknown,SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.,,,,,,
03/20/2014 05:11:49,spid8s,Unknown,.NET Framework runtime has been stopped.,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,Recovery is complete. This is an informational message only. No user action is required.,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,SQL Server is now ready for client connections. This is an informational message; no user action is required.,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,------------------------------------------------------,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,Execution of SSIS_DISCOVERY.SQL completed,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,------------------------------------------------------,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,Database SSISDB could not be upgraded successfully.,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,User 'sa' is changing database script level entry 17 to a value of 500.,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,Database SSISDB does not exist in current SQL Server instance,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,------------------------------------------------------,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,Starting execution of SSIS_DISCOVERY.SQL,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,------------------------------------------------------,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,Database 'master' is upgrading script 'ssis_discovery' from level 184551476 to level 184551594.,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,------------------------------------------------------,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,execution of UPGRADE_UCP_CMDW_DISCOVERY.SQL completed,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,------------------------------------------------------,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,Skipping the execution of instmdw.sql.,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,User 'sa' is changing database script level entry 15 to a value of 500.,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,The Utility MDW does not exist on this instance.,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,------------------------------------------------------,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,Starting execution of UPGRADE_UCP_CMDW_DISCOVERY.SQL,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,------------------------------------------------------,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,Database 'master' is upgrading script 'upgrade_ucp_cmdw_discovery.sql' from level 184551476 to level 184551594.,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,Completed upgrade of Database Mail related objects...,,,,,,
03/20/2014 05:11:48,spid8s,Unknown,Upgrading Database Mail related objects...,,,,,,

===================================================================

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-05-14 : 12:43:14

If it was auto-patched, then it's likely through SCCM or Windows Update. For servers, we only push the installer file down and then manually run it so that we can control when it happens as well as the failovers.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources