How to upgrade SQL 2005, 2008/R2 or 2012 SP1 to SQL Server 2014

SQL Server 2014 No comments

Upgrading SQL could be one of the most difficult task on the IT environment. Normally SQL administrators will prefer to deploy a new instance with the latest version then migrate the DBs and services . In my case I always try to utilize as much as I can from Microsoft features such as upgrading. We all know that is not always the best option but so far I have upgrade quite few important servers and no issues at all.

clip_image001

clip_image001

clip_image001

Here's the step by step on how to upgrade your SQL 2005, 2008, 2008 R2 and 2012 to 2014.

Download the new SQL 2014 installation media and run the setup, select installation then Upgrade

clip_image002

clip_image004

clip_image005

clip_image006

clip_image008

clip_image009

clip_image010

clip_image011

clip_image012

clip_image013

clip_image014

clip_image015

clip_image017

clip_image018

clip_image001[1]

clip_image019

No comments :

Post a Comment

Subscribe to: Post Comments ( Atom )