Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Replication detween embeded and sql databases

Created: 02 Nov 2012 | 12 comments
MiRzA's picture

Dear All,

1.Can we configur SYmantec endpoint protection replication between embbeded and sql databases ?

2. what will be the pros and cons of different type of databases ?

3. How many SEPM server can connect to single SQL database ?

we have two sepm servers and one sql database in loadbalacing on one site and we want configure an other SEPM server on DR site. what are yours suggestions to accomplish this requirement.

regards

shoaib

Comments 12 CommentsJump to latest comment

Ashish-Sharma's picture

HI,

Can we configur SYmantec endpoint protection replication between embbeded and sql databases

How replication works

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

How to install the Symantec Endpoint Protection Manager(s) for replication

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

You can certainly add another one without issue. I believe the max is 5

How many SEPM server can connect to single SQL database ?

Symantec Endpoint Protection (SEP) Sizing and Scalability recommendations

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

There shouldn't be any problem to add another SPEM for failover & loadbalancing.

Installing a management server for failover or load balancing

http://www.symantec.com/business/support/index?pag...

Determining how many sites you need

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

Check this thread

http://www.symantec.com/connect/forums/how-many-management-servers-can-i-have-site

SEP 11 replication between embedded database and SQL Server database?

http://www.symantec.com/connect/forums/sep-11-replication-between-embedded-database-and-sql-server-database

Difference between Replication and Failover

http://www.symantec.com/connect/forums/difference-between-replication-and-failover

http://www.symantec.com/connect/forums/failover-concept

Thanks In Advance

Ashish Sharma

Chetan Savade's picture

#Edit

Hi,

1.Can we configur SYmantec endpoint protection replication between embbeded and sql databases ?

--> Yes, it's possible.

Endpoint Protection Manager Replication between SEPM and Embedded databases

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

2. what will be the pros and cons of different type of databases ?

--> Embedded database support upton 5000 clients only per SEPM

3. How many SEPM server can connect to single SQL database ?

--> As per best practices it should not be more than five & Symantec strongly recommends that you do not exceed 10

SEP 11.x it SQL can connect upto 50,000 clients per SEPM & 80,000 in SEP 12.1.

we have two sepm servers and one sql database in loadbalacing on one site and we want configure an other SEPM server on DR site. what are yours suggestions to accomplish this requirement.

--> Could you please confirm total number of clients & currently how they are divided with load balancing?

Chetan Savade
Sr.Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

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

pete_4u2002's picture

1.Can we configur SYmantec endpoint protection replication between embbeded and sql databases ?

yes, it is possible to run replication

2. what will be the pros and cons of different type of databases ?

just make sure the data is not too much to replicated , as Sybase DB may not peform the same level as that of SQL when managing the huge DB size.

3. How many SEPM server can connect to single SQL database ?

best practices it should not be more than 5

Use the following size guidelines to decide how many sites to install:

        Install as few sites as possible, up to a maximum of 20 sites.

  • Connect up to 10 management servers to a database.

  • Connect up to 50,000 clients to a management server

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

MiRzA's picture

Dear All,

Thanks for all yours reply.

its very much helpfull , i need another query to confirm.

is it necessory that GUP should be in same Group as clients that are taking updates for GUP ?

Simpson Homer's picture

Is it necessory that GUP should be in same Group as clients that are taking updates for GUP ?

YES

MiRzA's picture

Hi Simson,

Thanks for your reply.

if you have document or any articl kindly share here regarding gup query.

Chetan Savade's picture

Hi,

Go through the following articles

Group Update Provider: Sizing and Scaling Guidelines

http://www.symantec.com/business/support/index?pag...

Best Practices with Symantec Endpoint Protection (SEP) Group Update Providers (GUP)

http://www.symantec.com/business/support/index?pag...

Forum Articles

https://www-secure.symantec.com/connect/articles/c...

http://www.symantec.com/connect/articles/how-analy...

Chetan Savade
Sr.Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

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

MiRzA's picture

Thanks for reply.

another query,,,,,,,,

is SPEM takes backup of contents resion in backup,, ?

Chetan Savade's picture

Yes it does.

Chetan Savade
Sr.Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

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

SMLatCST's picture

The below article suggests definitions are included in the SEPM native backups:

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

Incidentally, as per your earlier question, it is NOT required to place a GUP and the clients the GUP provides updates for, in the same group.  As long as the below requirements are met, the GUP and its clients can be in different groups and even have different policies applied!

  • The GUP knows it's a GUP (via the LU policy assigned to it)
  • The SEP clients know which GUP to use (via the LU policy assigned to them)
  • SEP Clients can contact GUP on configured port (2967 by default)
  • All managed can contact SEPM (on port 8014 by default)

Add to this the subnet requirements of the Multiple GUPs option and you're done.  As it is not out yet, I cannot confirm if these are also applicable to 12.1RU2, but I can confirm these are correct for 12.1RU1MP1 as I've tested it.

Chetan Savade's picture

Hi,

Please update this thread & Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.

Chetan Savade
Sr.Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

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