Upgrade fails from SQL Server 2008R2 to SQL Server 2014

After a great struggle & multiple tries, I was able to upgrade the DB engine to SQL 2014 from SQL Server 2008R2 for one of my client.

Earlier upograde was failing with the following message in Summary .txt Logs

The upgrade process for SQL Server failed. To continue the upgrade process, use the following information to resolve the error. Next, uninstall SQL Server by using this command line: setup /q /action=uninstall /instanceid=testXXX /features=SQLENGINE,FULLTEXT,REPLICATION. Then, run SQL Server Setup again.

Cause , someone had earlier tried to do the upgrade and was not succussfull. That is the reason I always advice let the DBA do the database stuff.navigated to the

To resolve the issue , I opened the command prompt and navigated to the following folder

%Program Files%\Microsoft SQL Server\100\Setup Bootstrap

At the command prompt, type the command that you identified in the Final Result entry in step 2, and then press ENTER. For example, if the Final Result entry resembles the example entry in step 2, type the following command, and then press

ENTER:setup /q /action=uninstall /instanceid=CLUSTER1 /features=SQLEngine,Replication,FullText After the unistallation is complete, restart the upgrade and succussfully upgraded tp to SQL Server 2014.