Prerequisites
If all is fine then congrats you have upgraded your sql server instance.
1) Run upgrade adviser on the databases for the instance you want to upgrade.
2) If any issues are found, talk to your SME for fixing the same.
3)If issues are fixed proceed with the actual upgrade. -- Do check for the other dependencies on the database which might effect the functionality if the instance gets upgraded or something like that.
4)Get the downtime for the database.
5)Create the latest full backup of the all databases -- any other strategy will also work, just make sure you can recover the database.
6)Take a clone of the server if it's a virtual server to roll back any changes.
7)Run the upgrade on the sql 2005 instance from the 2008 or 2008R2 or 2012 or 2014 set up. (do check the pre-requirements for upgrade to sql 2014)
8)If everything is fine then you have an upgraded instance.
9)you have to check the compatibility of the each database and update the new value of sql server which you have upgraded .
5)Create the latest full backup of the all databases -- any other strategy will also work, just make sure you can recover the database.
6)Take a clone of the server if it's a virtual server to roll back any changes.
7)Run the upgrade on the sql 2005 instance from the 2008 or 2008R2 or 2012 or 2014 set up. (do check the pre-requirements for upgrade to sql 2014)
8)If everything is fine then you have an upgraded instance.
9)you have to check the compatibility of the each database and update the new value of sql server which you have upgraded .
If all is fine then congrats you have upgraded your sql server instance.
