Upgrade to MS SQL 2012 Express SP4

[User43739009]

Hi, I'm running ePO 5.9.1 on MS SQL 2012 11.0.6615.2 Express Edition currently. Any issue or things to take note if upgrading to MS SQL 2012 Express Edition SP4 11.0.7001.0? Pls advise.

[vnaidu]

@User43739009 

I think you can go for it.

Microsoft SQL	ePO 5.10	ePO 5.9.1	ePO 5.9.0	ePO 5.3.0
SQL Server 2017 Express	Yes	Yes	No	No
SQL Server 2017	Yes	Yes	No	No
SQL Server 2016 Express	Yes	Yes	Yes	Yes 2
SQL Server 2016	Yes	Yes	Yes	Yes 2
SQL Server 2014 Express	Yes	Yes	Yes	Yes
SQL Server 2014	Yes	Yes	Yes	Yes
SQL Server 2012 Express	Yes	Yes	Yes	Yes
SQL Server 2012	Yes	Yes	Yes	Yes
SQL Server 2008 R2 Express	No	Yes	Yes	Yes
SQL Server 2008 R2	No	Yes	Yes	Yes
SQL Server 2008 Express	No	Yes 1	Yes 1	Yes 1
SQL Server 2008	No	Yes 1	Yes 1	Yes 1
SQL Server 2005 Express	No	No	No	No
SQL Server 2005	No	No	No	No

Cheers!!!!!

[User43739009]

Hi,

Thanks a lot for the info.

Is there anything to perform prior to the upgrade? E.g. stopping the ePO services? Running any commands?

Or just run the SP4 installer and reboot server upon completion?

.

[vnaidu]

@User43739009 

You may refer the KB article for any help KB76739. In addition, I have also come across the following discusssion. Feel free to have a look at it.

https://community.mcafee.com/t5/ePolicy-Orchestrator/Update-SQL-Express-for-ePO-Upgrade/td-p/448273

I hope this helps.

[cdinet]

The main thing you need to do before upgrading sql is to have a full backup of the database and the epo server file system per kb66616.  Turn off all epo services and any agent handlers prior to upgrading sql, then restart only the application server service first and log into the console to validate everything is functional before turning on the eventparser and server services.

[shiv0383]

I have my ePo database in the external sql server managed by SQL team , what is the best way for this. 

My SQL team has planned for the SP4 upgarde , do i need to stop my services of my epo? before the upgrade. Bcz we wont be knowing the status of SQL part during upgradation

Regards

Pranav 

[cdinet]

Yes, I would suggest turning off epo services and any agent handlers until the upgrade is complete.  Your DBA should know how to back up the epo database - just make sure they are going to do that.