Solved

SQL 2008 Service packs and Cumulative updates

Posted on 2013-11-12
2
390 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
2 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 300 total points
Comment Utility
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
Comment Utility
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now