4.4. Developing a service pack upgrade strategy
If you were to develop a list of the top ten issues that a group of DBAs will argue about, one that's sure to appear is the approach to installing service packs. Let's take a look at the various considerations involved before looking at a recommended approach.
4.4.1. Installation considerations
You must consider a number of important factors before making the decision to install a service pack:
Third-party application vendor support—Most application vendors include supported SQL Server versions and service pack levels in their support agreements. In such cases, a service pack upgrade is typically delayed until (at least) it becomes a supported platform.
Test environments—The ability to measure ...
Get SQL Server 2008 Administration in Action now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
