09-29-2017 07:37 AM
I'm running EV10.4 and SQL 2008 R2 and planning to upgrade to 11 and SQL 2012, my first step is to upgrade the DB, is there any particular issue to be considered to run an upgrade in place of the SQL server from 2008 to 2012 ?
09-29-2017 10:28 AM
No issues from the EV side really. Just consider the pros and cons from the SQL side. Have a look on this article: https://logicalread.com/sql-server-2012-in-place-upgrade-w02/#.Wc6BTNMjE6g
Also, I would suggest to take a backup of all EV databases and stop the EV services before starting the SQL upgrade.
10-02-2017 06:37 AM
Thank You Virgil!
Of course EV services will be stopped and there will be no access from application to db in the meanwhile.-
10-02-2017 07:20 AM
It's really easy, I did it many time for different client. You can use this technote of Veritas for move DB :
03-08-2018 12:37 AM
the article is great, but not really related to upgrading the SQL software.