Endpoint Protection

 View Only

  • 1.  SEPM DB Migration from SQL Server 2008R2 to 2012

    Posted Aug 24, 2017 01:57 AM

    Hey guys,

     

    I've been following this KB for the migration process:

    https://support.symantec.com/en_US/article.TECH132761.html

    But I have 2 question here:

     

    1. Does this apply also if I'm moving from 2008R2 to 2012?

    2. Would it also work if the SQL Server 2008R2 and the 2012  have different IP addresses?

     

    Thank you,



  • 2.  RE: SEPM DB Migration from SQL Server 2008R2 to 2012

    Broadcom Employee
    Posted Aug 24, 2017 02:34 AM

    1. Does this apply also if I'm moving from 2008R2 to 2012?

    Yes, it will work as it's Microsoft functionality.

    2. Would it also work if the SQL Server 2008R2 and the 2012  have different IP addresses?

    backup and restore does not depend on IP address, however when you run SEPM configuration wizard you have to enter the IP address of the new SQL server so that it will synch with the database.

     



  • 3.  RE: SEPM DB Migration from SQL Server 2008R2 to 2012

    Posted Aug 24, 2017 05:59 AM

    Would it affect the SEP clients if the SQL Server uses no IP address?



  • 4.  RE: SEPM DB Migration from SQL Server 2008R2 to 2012
    Best Answer

    Broadcom Employee
    Posted Aug 24, 2017 06:13 AM

    no, SEP clients to SEPM and not SQL.

    SEPM should be able to communicate to SQL, hence you need to run the configuration wizard for SEPM to point to the new IP address of SQL which has the backup restored.