Video Screencast Help

Disaster recovery SEP 12.1 RU2 and SQL

Created: 24 Apr 2013 | 6 comments
diabolicus23's picture

Hi all,

is there a step-by-step procedure in order to perform a disaster recovery procedure with SEP 12.1 RU2 and external SQL Database?

I've found a technote related to the embedded DB version.


Comments 6 CommentsJump to latest comment

Rafeeq's picture

Take backup from SQL or from SEPM then put it back

Disaster/Recovery- How to rebuild and restore your #1 Symantec Endpoint Protection Manager and re-connect it to your existing SQL database

diabolicus23's picture

Uhm... a little bit old. Infact it talks about multiple files instead of the single "group" created in new SEP version.

Nothing newer?

W007's picture


Look this dicussion

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

diabolicus23's picture

Useful but a little of confusion in it.

Moreover, the solution indicated refers to the embedded DB version.

Ambesh_444's picture


Agreed with Rafeeq,

please  check with this article.


1. Backup the SEPM server certificate As per Disaster Recovery Steps.
2. Backup the existing SQL 2005 database using SQL backup
3. Uninstall the Symantec Endpoint Protection Manager
4. Uninstall Microsoft SQL 2005 clients tools
5. Install Microsoft SQL 2008 client tools
6. Steps to perform on the SQL 2008 Server

a). Copy SQL 2005 backup Database to SQL 2008
b). Attach the database
c). Change the compatibility mode to 2008a
d). Create a user which will have admin rights on the

7. Reinstall the Symantec Endpoint Protection Manager
8. In Management Server Configuration Wizard point it to the
Microsoft SQL Server 2008 and use the existing database, when it asks
that the server exist do you want to overwrite click yes
9. Restore the SEPM server certificate. 

Best Practices for Disaster Recovery with the Symantec Endpoint Protection Manager

Best Practices guide for moving the Symantec Endpoint Protection Manager SQL Server database from one drive to another on the same machine.

Best Practices guide to moving the Symantec Endpoint Protection Manager SQL Server database from an existing SQL Server database to a new SQL Server database

Thank& Regards,


"Your satisfaction is very important to us. If you find above information helpful or it has resolved your issue. Please don't forget to mark the thread as solved."