Login to participate
Security BlogsRSS

Migrating SEPM DB to SQL 2008

Kedar Mohile's picture

Migrating SEPM DB to SQL 2008

The procedure would remain same as before. You might want to check the following

  1. Remove the SEPM from any replication setup with other SEPMs
  2. Backup the SEPM server certificate
  3. Backup the existing SQL database using SEPM backup and Restore wizard
  4. Install an instance of Microsoft SQL Server 2008
  5. Uninstall the Symantec Endpoint Protection Manager
  6. Reinstall the Symantec Endpoint Protection Manager configured to use a new Microsoft SQL Server 2008 database
  7. Restore the SEPM server certificate
  8. Restore the backup copy of the database
  9. Reconfigure the Symantec Endpoint Protection Manager database to recognize Microsoft SQL Server 2008 by running Management Server Configuration Wizard

Reference: Symantec Endpoint Protection Manager: Moving from the Sybase Embedded Database to Microsoft SQL Server
http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2007092722095248

Thanks :-)

snekul's picture

One of these days we'll get

One of these days we'll get around to migrating to SQL 2008 and Server 2008 for SEPM.  Is there any advantage to doing so--other then the advantages of the new OS and SQL itself?

Eric C. Lukens
IT Security Policy and Risk Assessment Analyst
University of Northern Iowa