• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • 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?
0
RayManAaa
Asked:
RayManAaa
2 Solutions
 
als315Commented:
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:
http://technet.microsoft.com/en-us/windowsserver/bb332157.aspx
0
 
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
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

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