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

Instruction on moving SEPM database to new SQL server

Created: 10 Apr 2013 • Updated: 02 May 2013 | 15 comments
This issue has been solved. See solution.

Hi,

We are running SEPM v11 RU7 on WinServer 2003 and Database on SQL Server 2005. We are about to move the database to a new SQL server (2008).

Please advise if the following symantec article is sufficient for the DB migration and the steps on changes in SEPM.

http://www.symantec.com/business/support/index?page=content&id=TECH132761

Also would like to find out how long will it take to complete this migration.

Thank you.

 

 

 

Operating Systems:

Comments 15 CommentsJump to latest comment

K33's picture

hi,

Find some more artical

How to move the Symantec Endpoint Protection Manager SQL database to a new SQL Server

Article:TECH174821  |  Created: 2011-11-18  |  Updated: 2012-01-06  |  Article URL http://www.symantec.com/docs/TECH174821

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

Article:TECH104723  |  Created: 2008-01-15  |  Updated: 2012-04-10  |  Article URL http://www.symantec.com/docs/TECH104723

Follow steps as per comments

https://www-secure.symantec.com/connect/forums/mig...

Chetan Savade's picture

Hi,

You can refer these articles

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

SQL admin will be the best person to complete this activity.

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

Mithun Sanghavi's picture

Hello,

Here are the perfect articles for your issue:

Migrating to Microsoft SQL 2008 from a previous version

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

How to move the Symantec Endpoint Protection Manager SQL database to a new SQL Server

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

Hope that helps!!

Mithun Sanghavi
Senior Consultant
MIM | MCSA | MCTS | STS | SSE | SSE+ | ITIL v3

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

danckli's picture

Thank you all on providing the information.

I was reading some blogs on this migration process as well and realised the procedure of migrating DB to SQL 2008 also requires backing up SEPM server certificate as well as uninstall & reinstall SEPM which will take heaps longer to carry out. Is that true?

Ta.

SebastianZ's picture

Not true. As per article mentioned above after moving the DB you will need only to run the Management Server Configuration Wizard on SEPM to point it to the new database server:

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

 

6. Run the Management Server Configuration Wizard to point the SEPM to the new database.

6a. If SEPM is already installed: Choose the option to Reconfigure the Management server. When prompted, enter the credentials for the sem5 user created in the steps above.

pete_4u2002's picture

does this help?

Symantec Endpoint Protection Manager: Moving from the embedded database to Microsoft SQL Server

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

SebastianZ's picture

I believe in this case it is a move from SQL to SQL - according to inital post:

We are running SEPM v11 RU7 on WinServer 2003 and Database on SQL Server 2005. We are about to move the database to a new SQL server (2008).

Ambesh_444's picture

Hi,

Please refer this..

http://www.symantec.com/business/support/index?page=content&id=TECH132761

http://www.symantec.com/business/support/index?page=content&id=TECH174821

 

Symantec Endpoint Protection Manager: Moving from the embedded database to Microsoft SQL Server

http://www.symantec.com/business/support/index?page=content&id=TECH102547

 

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/business/support/index?page=content&id=TECH104723

 

Thank& Regards,

Ambesh

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

SameerU's picture

Hi

To move embedded database to SQL you need to run Management Server Wizard Console and Select Database as "SQL Database"

Regards

 

SameerU's picture

Hi

Any update on the above mentioned query

Regards

 

danckli's picture

Thank you all for providing all the links.

I went through all of them and got the following statement:

With the migration from the embedded database to SQL database - the process of uninstall and reinstall SEPM is required. This is supported by the article ID: TECH102547

http://www.symantec.com/business/support/index?page=content&id=TECH102547

With the migration from the existing SQL database to the newer version (e.g. 2005 to 2008) - the process of uninstall and reinstall SEPM is NOT required. This is supported by the article ID: TECH104723 and a discussion in the forum.

http://www.symantec.com/business/support/index?page=content&id=TECH104723

http://www.symantec.com/connect/forums/migrating-sepm-db-sql-server-2005-2008-do-i-really-have-reinstall-sepm

This article might also be helpful.

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

I haven't started the migration process yet so I can't confirm the statement above is true. Will provide an update once this process is complete.

 

danckli's picture

Just a quick note. We have successfully migrated the SQL Database from 2005 to 2008. No SEPM re-install is required. All you need is to have the DB login and password. This process takes about 10 minutes to complete and the SEPM services will restore automatically.

SOLUTION