• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

SQL 2008 Service packs and Cumulative updates

Hello Everyone,

I would like to know from some DBA's out there how you handle SQL service pack upgrades and cumulative updates?  I have 70 SQL productions instances to take care of and I am the only DBA.  I also have 10 SQL test instances that mimic our more mission critical systems.  Basically I use the test SQL instances to manual install the service packs and cumulative updates before I install them into production.

I am trying to come up with an automated safe way to deploy the SP and cum updates to my test instances first.  Is there a third party tool that I can use to schedule the install the SQL service packs and cum updates and allow me to roll back the install (painlessly) if it failed?
2 Solutions
You can install freeware WSUS server, where you can have 2 or more groups of computers: test and production, for example. For test group you can use automatic approvement of updates, for production - manual.
You can download and find more info about WSUS here:
Ram BalachandranCommented:
Yes, WSUS is from Microsoft and the most trusted patch management application.
You can select the patches which dont want to be installed and will sync automatically from web with your list of server. You schedule the rollout.
How to configure WSUS - http://technet.microsoft.com/en-us/library/cc708446(v=ws.10).aspx
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now