Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

SEPM database migration to SQL 2008 question

Created: 27 Mar 2013 | 6 comments
Rinoa21's picture

Hi,,

 

I've migrated SEPM 12.1 database from SQL 2005 to SQL 2008 new server..it was successful..However, I need to double check what do i need to do on the SQL client installed on my SEPM server. It is still running on SQL 2005. Do I need to uninstall and install the SQL 2008 client? or no need? or can I upgrade it? or just leave it as it is.

Another question is, will my previous backup works in case I need to use it in disaster recovery. I ran that backup when my SEPM is still using SQL 2005. Now that I'm running SQL 2008..can I use thesame backup for restoration?

thanks,
 

Operating Systems:

Comments 6 CommentsJump to latest comment

W007's picture

hello,

Look this symantec public kb's

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

Moving the SEPM database to a new SQL server or instance using SQL backup/restore.

Article:TECH132761  |  Created: 2010-01-27  |  Updated: 2012-10-01  |  Article URL http://www.symantec.com/docs/TECH132761

Look this discussion

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

 

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

Rafeeq's picture

for better performance its good to upgrade your client tools aswell.

Your previous disaster recovery will work 

pete_4u2002's picture

Use the 2008 SQL client . Also make the latest DB copy from the existing DB version.

Mithun Sanghavi's picture

Hello,

The SQL Native client component installed on the SEPM machine has to be migrate to the Latest version of  SQL 2008 as well. 

Secondly, In terms of Backup, your older backup may work with the older version of SQL.

However in present situation it is recommended you to have the Latest backup of the Database which would with the Latest SQL.

Hope that answers.!!

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.

Chetan Savade's picture

Hi,

Agree with Mithun, SQL Native client component installed on the SEPM machine has to be migrate to the Latest version of  SQL 2008 as well.

There should not be any problem to restore SQL 2005 database into the SQL 2008.

Next SQL backup schedule should take the latest version backup.

 

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