Applying a Service Pack or Cumulative Update to an Existing Installation
If you want to apply a service pack or cumulative update to an existing SQL Server installation, you’ll need to download the service pack or cumulative update executable and apply it to the existing installation.
Before applying a service pack or cumulative update to an existing SQL Server installation, make sure to back up all user-created databases, as well as the system databases master, model, msdb, and any replicated databases. If you have installed Analysis Services, back up the entire OLAP directory (as discussed earlier in this chapter in the “Installation Paths” section) and all its subdirectories.
You also should make sure to close all open connections to the instance ...
Get Microsoft® SQL Server 2012 Unleashed 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.
