The installation time varies depending upon the hardware configuration. In Upgrade Progress screen you will be able to see the installation progress.If you are fine with the list of features, then click Upgrade to perform the actual Service Pack 2 installation. In Ready to Upgrade screen you can verify the list of features which will be upgraded during the installation.

Click Next to continue with the installation.

If there are any such files, then they need to be released before performing the Service Pack installation.

In Check Files In Use screen the setup will check for SQL Server related files which are currently being used.

Once all the features are selected click Next to continue with the SQL Server 2016 Service Pack 2 (SP2) installation.

In Select Features screen, select the SQL Server Instance and select the features of SQL Server 2016 which need to be upgraded.

In License Terms screen, read the license agreement and then select the check box at the bottom of the page to accept the licensing terms and conditions of the product.

Right click exe and ‘Run as administrator’.

Download SQL Server 2016 Service Pack 2 (SP2) from the following link.

Steps to Install SQL Server 2016 Service Pack 2 (SP2)

Upgrade your SQL Server installation to the latest SQL Server 2016 Service Pack before applying the latest CU’s.

Test both SP’s and CU’s before you deploy them to production environments.

Also, I recommend that before applying any Service Pack on SQL Server, you should take a full backup of all the user and system databases including the Resource database.

But I do recommend restarting the server after each installation.

Both the Service Pack 2, and CU11 will automatically restart the Database Service, but they are NOT going to automatically reboot the Server after installations, and they do not require it.

So, in my opinion each SQL Server SP’s and CU’s are very important hotfixes that need to be applied after initial upgrade.īelow is the step by step guide on Installing the first Service Pack for SQL Server 2016 (Service Pack 2) then following that up with Cumulative Update 11 (CU11).īut before we start here are several of personal recommendations: Microsoft usually releases SP’s and CU’s to fix hundreds of bugs after the initial releases of the SQL Server 2016 RTM, and they have also has been adding a significant number of product improvements and new features after the RTM release.

Website Content Management Systems (CMS).

Pure Html5/react.js/node.js Web Development.

Business Intelligence Infrastructure Implementation.

Battlefield 2 servers 2016