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

Migrating SEPM DB to SQL 2008

Created: 28 Sep 2009 • 2 comments
Kedar Mohile's picture
+5 5 Votes
Login to vote

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

Comments 2 CommentsJump to latest comment

snekul's picture

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

-5
Login to vote
steffen910's picture

good one

-1
Login to vote