Endpoint Protection

 View Only

  • 1.  SQL 2008 SP1 upgrade to SQL 2016

    Posted Sep 12, 2017 11:29 AM

    Hello everybody,

    Currently I am in the process of upgrading from SEPM 12.1.6 to SEPM14 MP2. During this upgrade process we need to upgrade our SEP database from SQL 2008 SP1 to SQL 2016 due to system requirments.

    I was wondering what the best route would be to upgrade this database. Also, if anyone has performed this upgrade as the first time we attempted this upgrade we were able to connect to the database and then it stopped working about 15 minutes after the upgrade. So we are just looking for any suggestions or issues that might occur.

    Thank you,

    Jack McAloon



  • 2.  RE: SQL 2008 SP1 upgrade to SQL 2016
    Best Answer

    Trusted Advisor
    Posted Sep 14, 2017 05:28 AM

    Hello,

    As long as you have the backup done you should be fine, similar steps here:

    http://www.symantec.com/docs/TECH162881

    Best Practices guide for moving the Symantec Endpoint Protection Manager SQL Server database from one drive to another on the same machine

    http://www.symantec.com/docs/TECH106213 

    Best Practices guide to moving the Symantec Endpoint Protection Manager SQL Server database from an existing SQL Server database to a new SQL Server database

    http://www.symantec.com/docs/TECH167300