Although service packs or thoroughly tested Microsoft recommends to test it in your UAT environmentīefore proceeding with deployment in production environment. Make sure you test all your application functionalities completely. Please follow below steps before upgrading SQL Server 2012 to SP2.ġ.PLEASE first install Service pack on UAT/Test environment and test your application thoroughly. I highly recommend readers to please read all the sections If you browse this link you will be directed to page containing SQL Server 2012 SP2 on the same page there are various section on Details, System Requirements and Install Instruction. To begin, first please download SQL Server 2012 SP2 from Steps to install SP2 would be same but few precautions needed to be taken care of. If you are trying to Install Service pack on database which had Mirroring configured on it please refer to I should also add that I also tried upgrading to 2008 r2 express but that also failed for a similar reason.This article provides step by step method with screenshots on how to install SQL Server 2012 Service Pack 2(SP2) on standalone SQL Server instance.

I also ran a discovery report and this looked as follows:Ĭan anyone explain what the cause of this may be? To retry the upgrade, remove the upgraded feature that failed, and then run the upgrade again. I end up with the following error: Rule 'Previous upgrade' failed.Ī previous upgrade that failed was detected. Originally the Engine was 2005 but I upgraded to 2008 and then 2008 service pack 2 (all 32bit) I've been downloading 32 versions to run as the existing version was a 32 bit one. I'm running on a 64 bit machine so I downloaded the SQLEXPRE_x86_ENU file from this link. I'm trying to upgrade to SQL Server 2012 Express. 0 (Intel X86)Ĭopyright (c) 1988-2008 Microsoft CorporationĮxpress Edition on Windows NT 6.1 (Build 7601: Service Pack 1) (WOW64)

I have the following version of SQL Server Express installed on my local machine: Microsoft SQL Server 2008 (SP2).

Sql server 2012 express sp2 upgrade