Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2008 SP/CU Patching Through Windows Scheduled Tasks


SQL 2008 SP/CU Patching Through Windows Scheduled Tasks

Author
Message
Shawn Melton
Shawn Melton
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1099 Visits: 3492
S.K. (5/3/2011)
As for using WSUS, I never really looked into it, but some of our hosts are not internet-connected (behind firewalls), so downloading the patches directly would be a problem, and for hosts that are internet connected, we'd need to run windows update multiple times to get the updated CU's after the SP is installed, wouldn't we?

Yes, I have heard of folks that have issues with SCCM and it is not a popular tool to use in patching SQL Server. WSUS acts a little different than the Windows Update agent on a server/desktop. WSUS gets a list of all patches available after they are released from Microsoft. There is a sync task that is used to "sync" your WSUS server with Microsoft servers for the patches that are available and shown needed within your servers/desktops.

It has been a few years since I administered a WSUS environment but of what I do remember you would pretty much put your SQL Servers in a group. Within that group you tell WSUS what product to check for patches on, yours being SQL Server. It will then sync with Microsoft to find out what the current patches/CUs are and if that server has them installed. You can require prior approval before deploying the patch or CU that is needed.

As far as Internet connectivity goes there are ways around that I believe with the new version of WSUS. I do believe you can manually put the patch or CU within the repository for WSUS. With firewalls I have seen environments that will have one WSUS that is allowed Internet access only to the Microsoft WSUS server to download the patches. Then the internal WSUS servers all talk to that server like a parent-child relationship. Each WSUS server will sync up to the one WSUS that has Internet access. This provides a more secure environment and does not require opening up Internet access to all your servers.

Shawn Melton
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
S. Kusen
S. Kusen
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1092 Visits: 1108
Yes, I have heard of folks that have issues with SCCM and it is not a popular tool to use in patching SQL Server. WSUS acts a little different than the Windows Update agent on a server/desktop. WSUS gets a list of all patches available after they are released from Microsoft. There is a sync task that is used to "sync" your WSUS server with Microsoft servers for the patches that are available and shown needed within your servers/desktops.


I suppose it becomes a matter of personal preference. I'll definitely check out WSUS to see what it has to offer, but it sounds like another tool we'd need to administer, whereas the batch files or powershell scripts are items we can have full control over without really having to rely on agents or tooling to roll out the updates.

Best Regards,
Steve
SQLRNNR
SQLRNNR
SSC-Insane
SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)SSC-Insane (21K reputation)

Group: General Forum Members
Points: 21053 Visits: 18258
Thanks for the nice article.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

S. Kusen
S. Kusen
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1092 Visits: 1108
SQLRNNR (5/3/2011)
Thanks for the nice article.


Thanks, Jason!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search