Installing a Service pack for SQL Server cluster

Recently, I installed an SQL Server service pack and a CU update for a client. Here are my notes.

SQL Server 2012 was presently running the RTM build. The plan is an upgrade to SQL Server 2012 SP2, then SQL Server 2012 SP2 CU3.

Any good upgrade path begins with a test plan. It is recommended to test implementation on a test cluster which mirrors the production instance.

Test plan

Phase

Task

Node

Actions

Prerequisites

     
 

Stage Source: SQL Server 2012 SP2 & CU3

Active/Passive

 

Check database integrity & consistency

Active

 

Free space; master & tempdb

Active

 
 

Full Backups: system and user dbs

Active

 
 

Verify free space on nodes

Active

 
 

Verify SQL Server build version

Active

 

Installation

     
 

Install SQL Server 2012 SP2

Passive

Reboot

 

Install SQL Server 2012 SP2 CU3

Passive

Reboot

 

Failover SQL Server nodes

Active to Passive

 
 

Install SQL Server 2012 SP2

Passive

Reboot

 

Install SQL Server 2012 SP2 CU3

Passive

Reboot

       

Verification

     
 

Verify SQL Server services are online

Active

 
 

Verify SQL Server build version

Active/Passive

 
 

Examine SQL Server install log

Active

 
 

Test basic SQL Server instance connectivity

Active

 
 

Test application(s)

Active

 
       

Rollback test

     
 

From Add/remove programs: remove CU3

Passive

Reboot

 

Failover SQL Server nodes

Active to Passive

 
 

From Add/remove programs: remove CU3

Passive

Reboot

 

Verify SQL Server services are online

Active

 
 

Verify SQL Server build version

Active/Passive

 
 

Test basic SQL Server instance connectivity

Active

 
 

Test application(s)

Active

 
       
 

From Add/remove programs: remove SP2

Passive

Reboot

 

Failover SQL Server nodes

Active to Passive

 
 

From Add/remove programs: remove SP2

Passive

Reboot

 

Verify SQL Server services are online

Active

 
 

Test basic SQL Server instance connectivity

Active

 
 

Verify SQL Server build version

Active/Passive

 
 

Test application(s)

Active

 

Upgrade Sequence

Prerequisites

To Install SQL Server 2012 Sp2, recommend minimum of 3GB free disk space.

To Install SQL Server 2012 Sp2 CU3, recommend minimum of 1.7GB free disk space.

Check database integrity and consistency, using Ola Hallengrens’ script.

Verify current SQL Server version

The following table lists the major releases of SQL Server 2012.

Release

Product Version

SQL Server 2012 Service Pack 2

11.0.5058.0

SQL Server 2012 Service Pack 1

11.00.3000.00

SQL Server 2012 RTM

11.00.2100.60

From <http://support.microsoft.com/kb/321185>

To Verify Active/Passive node, Open Failover Cluster Manager.

Service Pack Installation

 

SQL Server 2012 Sp2 Update

From passive node, browse to SQL Server 2012 Service Pack, right click setup.exe, run as administrator

image

 

Setup Support Rules; and Click OK

 

And, Click Next >

image

Click "I accept the license terms" and Click Next >

image

Accept defaults, and click Next >

image

When checking files is complete, and Click Next >

image

Ready to Update; and click Update

 Note:  shows current patch level of SP2

image

Completion Dialog, all features should show a status of Succeeded

image

To verify installation results, review SQL Server log directory, navigate to:

C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap

With notepad, open and review Summary.txt

Exit code should read 0.

Reboot passive node.

SQL Server 2012 Sp2 CU3 Update

From passive node, browse to CU update folder, right click setup.exe, run as administrator

image

Setup Support Rules; and Click OK

image

And, Click Next >

image

Click "I accept the license terms" and Click Next >

image

Accept defaults, and click Next >

image

When checking files is complete, and Click Next >

image

Ready to Update (CU3), and click Update

(Note: highlight below – shows current patch level of SP2)

image

Completion Dialog, all features should show a status of Succeeded

image

Review Summary.txt

Exit code should read 0

image

Patch level for CU3 is 11.2.5556.0

Reboot passive node

From Active node, verify that Failover Cluster Manager shows the passive node back online.

RDP to updated node, review Server event logs, verify SQL Server services are correct

Failover from Active to Passive

Final Steps

Repeat SP2 install on Passive Node

Repeat CU3 update on Passive Node

Reboot Passive node

Launch SQL Server Management Studio

Verify SQL Server version

image

image

Failover instance, and verify version and application connectivity.

Reference: http://blogs.msdn.com/b/askjay/archive/2011/02/07/uninstalling-a-sql-server-service-pack.aspx

Advertisements
This entry was posted in SQL Server, SQL Server 2012. Bookmark the permalink.

One Response to Installing a Service pack for SQL Server cluster

  1. Pingback: Rollback procedure for SQL Server updates | Steve Thompson [MVP]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s