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

Moving EndPoint Protection SQL 2005 Database

Created: 04 Sep 2013 • Updated: 05 Sep 2013 | 5 comments
This issue has been solved. See solution.

Following the directions layed out by Symantec, I would stop the services for the SYmantec EndPoint Manager and then go through the instructions provided by Microsoft to move the SQL 2005 database to a new drive.  Great!  So, how do I point the Symantec EndPoint Manager to the new database location?

Thanks,

Joseph

 

Operating Systems:

Comments 5 CommentsJump to latest comment

.Brian's picture

Run the Management Server Configuration Wizard and you can change the DB info during this process.

See steps here (starts at step 7):

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

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

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

SOLUTION
Chetan Savade's picture

Hi,

Thank you for posting in Symantec community.

I would be glad to answer your query.

You should refer this article to accomplish this task.

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

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

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.<

SOLUTION
Rapoport1965's picture

Thank you both for your answers. Now if the DB is not a SQL DB and resides inside the Symantec EndPoint Manager folder, what are my options? IS there a way to empty the DB and have it start over, or should I be considering pointing this to a new DB in the same folder after deleting the old DB file? What would be the best way to accomplish this?

.Brian's picture

The embedded DB can't be moved. You would need to move the SEPM to a new machine or re-install.

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

Chetan Savade's picture

Hello,

In that case you need to perform disaster recovery.

Symantec Endpoint Protection 12.1: Best Practices for Disaster Recovery with the Symantec Endpoint Protection Manager

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

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.<