December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 UnleashedBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...