Agent Jobs

How To Install SQL Server 2014 Service Pack 1 and CU6

Here are some quick instructions on Installing the first service pack for SQL Server 2014 ( Service Pack 1 ) then following that up with CU6.
A couple of things before we begin… Both the Service Pack, and CU6 will automatically restart the Database Service, but this does NOT automatically reboot the Server after installation, and it does not require it. As usual; I do always recommend restarting the server after any Microsoft Server installation.

Download Service Pack 1, and ‘Run as administrator’.

It will auto-extract, and begin the setup process.

Accept the license terms and click ‘Next’.

Click ‘Next’.

Click ‘Next’.

Click ‘Update’.

Be patient as the update completes.

Click ‘Close’.

Here’s a basic query to return the SQL Server Versioning.

use master;

set nocount on

select

‘server name’ = upper(@@servername)

, ‘product name’ = left(@@version, 35)

, ‘product build’ = right(@@version, 35)

, ‘edition’ = serverproperty(‘edition’)

, ‘service pack’ = serverproperty(‘productlevel’)

, ‘sql build’ = serverproperty(‘productversion’);

You’re now up to version SQL Server 2014 SP1 which is reflected simply as Microsoft SQL Server 2014 – 12.0.41.

Right-click the CU6 file, and select ‘Run as Administrator’.

Click ‘Next’.

Click ‘Next’.

Click ‘Next’.

Click ‘Update’.

Be patient as the update completes.

Click ‘Close’.

You’re done.

Check your versioning once again, and you should be up to SQL Server 2014 SP1-CU6 v. 12.0.4449.0

use master;

set nocount on

select

‘server name’ = upper(@@servername)

, ‘product name’ = left(@@version, 35)

, ‘product build’ = right(@@version, 35)

, ‘edition’ = serverproperty(‘edition’)

, ‘service pack’ = serverproperty(‘productlevel’)

, ‘sql build’ = serverproperty(‘productversion’);

Advertisements

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