In-place Upgrade from SQL Server 2008R2 to SQL Server 2014

I had a change scheduled to perform In-place upgrade from SQL Server 2008R2 to SQL Server 2014.

SQL Server 2014 upgrade supports from following versions of SQL Server:

  • SQL Server 2005 SP4 or later
  • SQL Server 2008 SP3 or later
  • SQL Server 2008 R2 SP2 or later
  • SQL Server 2012 SP1 or later

I have downloaded SQL Server 2014 media directly from Microsoft site. Once the downloading is finished, double click the file to begin the installation. 

After double clicking on SQL Server setup, the SQL Server Installation Center window will open. On the left side click Installation TAB it will show different installation options. For this change, we will click on “Upgrade from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012”. This will itself launch the Upgrade wizard to SQL Server 2014 .

The Upgrade to SQL Server 2014 gives the steps it will follow on the left side of the wizard. Provide the product key and click “Next >”.

Review the license terms, click on “I accept the license terms”, and then click “Next >”.

The Global Rules TAB will check and let us know if there are any Rules failed to stop this Installation

Here I have SLIP STREAMED SQL 2014 Media with SP3 and HotFix So, that we can eliminate Multiple Reboots of Server and also SAVING TIME. From below ScreenShot we can observe the difference of Include SQL Server Product Updates checkbox ENABLED  ( Service Pack 3 and HotFix which was added to Installation Media )

In Install Setup Files wizard the upgrade application will download, extract and install files which are needed to carry out the installation process. Click on “Next >” to continue.

Select the SQL Server instance to modify. Click on “Next >” to continue.

The next step is the feature selection. Here I have selected all of the features to be upgraded. Click on “Next >” to continue.

The Instance Configuration screen allows the installer to provide the instance ID and here we can also see other installed instances on the server. Here mine is a default instance MSSQLSERVER on SQL Server 2008R2 which will be upgraded to SQL Server 2014.

The Server Configuration screen lists the services which are getting installed, we can provide or change the service account name and the Startup Type. Click on “Next >”.

The Full-text Upgrade screen lists us the three Full-Text upgrade options (import, rebuild and reset).

The Ready to Upgrade screen shows all of the features, prerequisites to be installed or upgraded. At this point, we can still go back to make modifications or quit the process. Once all are set then click on “Upgrade” to begin the upgrade of the SQL Server 2014 components.

The upgrade progress bar shows the status of upgrade.

After completion of installation, click on “Close” to exit the Upgrade to SQL Server 2014 application.

We have to restart your computer for the changes to take place

Verify all Features which are showing as Succeeded in the Status column, then click Close.

Finally, restart your server. Once server is restarted, Connect to Instance and see the Upgraded SQL Server 2014.

Author: Sri

Hello Friends, This blog is to help the IT professionals who want to become a professional SQL Server DBA but don't know how and from where to start with. So, I am going to share my experiences and my learning in this blog. Will talk about what are the pre-requisite skills required to become a Professional SQL Server DBA, how much time it takes to be a good DBA and what are the additional skill sets are required to become a good DBA. Apart from that I will also post real time sql server settings on server level and database level, Configuring High Availability. Also will share the Client requirements with real time setups if possible I will provide you with screenshots.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.