Upgrade SQL Server Edition–SQL Server 2008 R2

There will be some incidents that you need to upgrade Existing SQL Edition to another Such as Standard to Enterprise. in my scenario I had a SharePoint Foundation Farm Installed on a SQL Express 2008 R2 and I needed to upgrade it in to Enterprise due to huge growth of Databases. finally it became crucial while giving me an error when restoring a Database of 50 GB as SQL Express 2008 R2 allowed only 10GB Max and that’s where this upgradement decided.

nothing much to do as you have got the feasibility for this on SQL installer. just take below few steps to complete you Edition upgrade.

1. Run SQL Server Installer Setup from your media.

image

2. Direct to – Maintenance –> hit on Edition Upgrade

image

3. Place License Key and click next.

Capture

4. Agree to the License Agreements here

image

5. Select the instance which you need to upgrade as below and click next.

image

6. Make sure on everything by looking at the summary and hit Next to proceed with upgrading.

image

7. Give it a moment and you will see the below result as success shortly.

image

that’s it and your instance is upgraded for selected edition and there will be no harm to Databases or any settings you have done in the instance. Enjoy !

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