Endpoint Protection

Hi ,

I have 3 SEPM, SEPM A and SEPM B located in Site X and SEPM C is located in Site Y

All 3 SEPMs are installed to use MSSQL

Site X has a MSSQL DB that is in a cluster, and site Y has another DB that will replicate from the MSSQL DB.

At one time all the 3 SEPM will be pointing to the MSSQL in Site X, in the event when the MSSQL in Site X is down, all 3 SEPM will point to the DB in Site Y.

I would like to know if this is a workable solution and how do i go configuring it?

Thanks

This should help you get started  - http://www.symantec.com/business/support/index?page=content&id=HOWTO55323&actp=search&viewlocale=en_US&searchid=1340955803543

...than a SEP question.  You'll need to consider if you'll be using mirroring or clustering in SQL, and how the SEPMs will connect to the DB in either case.

As far as SQL clustering goes, all SEPMs would connect to the instance containing the SEP DB via the clustername.  This instance would then move back and forth depending on which SQL Server is serving it at the time, and the SEPMs would follow (I think!).

SQL Mirroring would require you either do some DNS jiggerpokery to redirect the SEPMs, or run the SEPM Config Wizard to repoint the SEPMs, at the other SQL Server in the event of the primary one falling over.

I'd highly recommend you read up on the SQL side of things for a better understanding of it all.

On another note, is there any reason you don't want to setup SEP replication between the two sites, and just have Management Server Lists set so the SEP Clients will failover across the sites/SEPMs?

Is there a way for the SEPMs to detect that the database in Site X is down and swing over to the Site Y automatically?

That's what an SQL Cluster handles.  Again, that is an SQL technology and not a SEP one.  So it's SQL that detects a DB Server is down, and moves the SQL Instance to another box.  The SEPM's just follow the instance around is all.

Is there SQL hardware specific requirements for SEP 12 DB? What would be the most optimal for about 43000 clients running with 4 SEPM's? Either SQL 2008 or SQL 2012 would do?

Is there SQL hardware specific requirements for SEP 12 DB? What would be the most optimal for about 43000 clients running with 4 SEPM's? Either SQL 2008 or SQL 2012 would do?

SQL should be on 2008

check this system requirement

http://www.symantec.com/business/support/index?page=content&id=TECH174720

Planning to upgrade to SQL 2012 - according to Symantec doc. How many SQL servers to make up the cluster would be sufficient - 2 or 4 servers for SQL 2012?

If we stay on SQL 2008 would I need 2 or 4 servers for SQL cluster?

2012 does not list in the supported sql version.

cluster is the customer requirement. it can be 2.

I received a document from a symantec updated for SEP 11Ru7mp2 that suggests otherwise - it includes SQL 2012 is vaild.