Video Screencast Help

SEPM Upgrade with mirror the SQL database

Created: 06 Jun 2013 | 5 comments
SV's picture

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.

Operating Systems:

Comments 5 CommentsJump to latest comment

ᗺrian's picture

You can follow this KB

Upgrading or migrating to Symantec Endpoint Protection 12.1.2 (RU2)

padding: 1px;padding-bottom: 3px ;font: 12px Arial; text-align: left;">Article:TECH197426 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 0px;font: 12px Arial; text-align: left;">Created: 2012-09-27 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 1px;font: 12px Arial; text-align: left;">Updated: 2013-01-14 padding: 1px;font: 12px Arial; text-align: left;"> |  padding: 1px;font: 12px Arial; text-align: left;">Article URL

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

SV's picture

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

AjinBabu's picture


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



SMLatCST's picture

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):

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

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!

Mithun Sanghavi's picture


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.


SEPM support for SQL database mirroring

Secondly, check these Articles:

Does the SEPM support use of Microsoft SQL database mirroring?

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

Hope that helps!!

Mithun Sanghavi
Associate Security Architect


Don't forget to mark your thread as 'SOLVED' with the answer that best helped you.