Endpoint Protection

 View Only

  • 1.  SEPM Upgrade with mirror the SQL database

    Posted Jun 06, 2013 10:55 AM

    Hello All,

    I am pleaning to upgade our SEPM to 12.1.2, right now we are using SEP 11 RU 6a

    we have two SEPM servers and both having single SQL DB (Load Balancing),

    at the same time the SQL DB is also mirred with the other server.

    please help me how to upgrade my SEPM's to 12.1.2 with the above settings.



  • 2.  RE: SEPM Upgrade with mirror the SQL database

    Posted Jun 06, 2013 10:57 AM

    You can follow this KB

    Upgrading or migrating to Symantec Endpoint Protection 12.1.2 (RU2)

    Article:TECH197426  |  Created: 2012-09-27  |  Updated: 2013-01-14  |  Article URL http://www.symantec.com/docs/TECH197426

     



  • 3.  RE: SEPM Upgrade with mirror the SQL database

    Posted Jun 07, 2013 07:16 AM

    Thankls Brian but i want how to upgrade SEPM while SQL DB is mirred with the other server.



  • 4.  RE: SEPM Upgrade with mirror the SQL database

    Posted Jun 07, 2013 07:25 AM

    Hi, 

    You have to break the mirror and upgrade both SEPM's and recreate the replication.

    Regards

    Ajin



  • 5.  RE: SEPM Upgrade with mirror the SQL database

    Posted Jun 07, 2013 07:45 AM

    This is more a SQL question than a SEP one, but generally speaking any changes made to the principal DB will be mirrored to the Mirror (according to a quick google):

    http://stackoverflow.com/questions/1301298/how-do-i-make-schema-changes-to-a-mirrored-database
    http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/5c3efc77-3f3b-4571-a6b9-52b0d86161da
    http://www.sql-server-performance.com/forum/threads/schema-changes-on-princicpal.2734/

    This means you should be able to progress with the SEPM upgrade as if it were just the one DB, and rely upon SQL's own processes to ensure the mirrir is updated accordingly.  Obviously, backup everything before proceeding wink

    #EDIT#
    Incidentally, I thought you may be interested in the below articles.  Not relevant to your current question, but it seems you're currently running an unsupported configuration and should move to SEP12.1 PDQ!

    http://www.symantec.com/docs/TECH197215
    http://www.symantec.com/docs/TECH104865
    http://www.symantec.com/docs/TECH197242



  • 6.  RE: SEPM Upgrade with mirror the SQL database

    Trusted Advisor
    Posted Jun 10, 2013 10:15 AM

    Hello,

    SEPM Database on SQL server with Mirroring is Supported with SEP 12.1.

    When the SEPM Database connection wizard is run, specify an IP address or machine name hosting the database. As long as that IP address is available, the SEPM will connect to it. However, the SEPM cannot natively “failover” between two databases. Thus if you implement database mirroring, the content of the DB will be available, but you will have to re-run the wizard to reconfigure the database IP address though you may only have to stop and restart the SEPM services to get the SEPM pointed to the proper address.

    An alternative method is that the customer uses an Availability Group Listener for SQL which will give a virtual network name (VNN), virtual IP (VIP), this VIP or VNN can be used to configure the SEPM database. The Availability Group Listener will ensure that it connects to the correct SQL database.

    Reference:

    SEPM support for SQL database mirroring

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

    Secondly, check these Articles:

    Does the SEPM support use of Microsoft SQL database mirroring?

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

    Best practices for upgrading to the latest version of Symantec Endpoint Protection 12.1.x

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

    Hope that helps!!