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

.Brian's picture

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

 

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

Hi, 

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

Regards

Ajin

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

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

Mithun Sanghavi's picture

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!!

Mithun Sanghavi
Senior Consultant
MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

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