Solved

SQL 2008 Service packs and Cumulative updates

Posted on 2013-11-12
2
403 Views
Last Modified: 2014-01-08
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
Comment
Question by:RayManAaa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 300 total points
ID: 39642443
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
 
LVL 14

Assisted Solution

by:Ram Balachandran
Ram Balachandran earned 200 total points
ID: 39642472
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

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question