How to upgrade SQL 2005, 2008/R2 or 2012 SP1 to 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.

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