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,
 

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/migrating-sepm-database-sql-2005-sql-2008

Read the below Migrating to Microsoft SQL 2008 from a previous version Article:HOWTO17917 | Created: 2009-01-02 | Updated: 2011-07-08 | Article URL http://www.symantec.com/docs/HOWTO17917 https://www-secure.symantec.com/connect/forums/move-sepm-database-sql-2005-sp3-sql-2012 https://www-secure.symantec.com/connect/forums/disaster-recovery-procedure-sep-121-ru1 https://www-secure.symantec.com/connect/forums/migrate-sepm-database-sql-2005-sql-2008 Migrating SEPM DB to SQL 2008 https://www-secure.symantec.com/connect/blogs/migrating-sepm-db-sql-2008

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

Your previous disaster recovery will work 

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

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

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.