Endpoint Protection

 View Only
  • 1.  Microsoft SQL 2008 database versus embedded database

    Posted Apr 16, 2012 11:04 PM

    What are the advantages of using the Microsoft SQL 2008 database versus the embedded database?

    Thank you



  • 2.  RE: Microsoft SQL 2008 database versus embedded database
    Best Answer

    Broadcom Employee
    Posted Apr 16, 2012 11:19 PM

    Embedded DB is good for clients less than 5000. If you are looking for failover or load balance then SQL is the only option.

    Embedded DB has limited DB size as compared to SQL.



  • 3.  RE: Microsoft SQL 2008 database versus embedded database

    Posted Apr 16, 2012 11:31 PM

    check this link

    High Availability (HA) designs take advantage of multiple Symantec Endpoint Protection Manager installations and multiple, clustered databases to provide redundancy, failover, and disaster recovery. Several options are available to optimize performance, fail-over, and recovery. For instance, the HA design can be configured to have client computers automatically switch to an alternate Symantec Endpoint Protection Manager server should the primary server become unavailable.

    https://www-secure.symantec.com/connect/forums/migrating-sepm-database-sql-2005-sql-2008

     


  • 4.  RE: Microsoft SQL 2008 database versus embedded database

    Posted Apr 16, 2012 11:32 PM

    If there are more than 5,000 clients to be managed, or you need failover and loading balance, or you need a SEPM for replication. MS SQL 2005/2008 database is recommended.

    you can find the answer in " Implementation_Guide_SEP12.1.pdf" which can be downloaded from Symantec website.

     



  • 5.  RE: Microsoft SQL 2008 database versus embedded database

    Posted Apr 17, 2012 05:15 AM

    In small, simple environments the embedded databse is fine and adequate.

    In busy environments with many thousands of clients, I recommend placing the SEPM database on a seperate server so that all of the storage, RAM, CPU, IO, etc of the SEPM can be devoted to service updates, policies, logs etc to its clients.  Database tasks can be offloaded and handled by a dedicated, high-powered SQL server.



  • 6.  RE: Microsoft SQL 2008 database versus embedded database

    Posted Apr 19, 2012 08:30 PM

    Thank you all very much for your on-point answers.  I have way less than 5,000 clients, so I was thinking of sticking with the embedded database. However, last year our SEPM server died, and it took us a  few rough hours to rebuild VM machine, install, and get SEPM up and running smooth again.  As a result, we are considering setting up the failover option as a quicker disaster recovery option.  So, even though we only have a few hundred clients, it looks like MS SQL 2005/2008 database is recommended option if we want to add failover.