Video Screencast Help

Migrating SCSP & DB

Created: 06 Feb 2013 • Updated: 11 Feb 2013 | 4 comments
indromojo's picture
This issue has been solved. See solution.

Hi There,

IHAC customer that running on SCSP 5.2.4 - SQL SVR 2000 SP4 and now they want to migrate into SCSP 5.2.9 - SQL SVR 2008 R2 SP1

Using the same IP Address & Host Name on the new hardware

The same condition has been posted previously on:

But the information about the step-by-step is still not quite clear. I have seek for the articles and found this : 

And I have a challenge in prioritizing which step should i started first, especially to do the DB Migration

Could anyone of you shed some light for this case? Appreciate your response

Comments 4 CommentsJump to latest comment

pete_4u2002's picture

check these links

Things to Consider When Moving the Symantec Critical System Protection (SCSP) Database and Management Server

Move Manager or DB to a New Server

you can do it any of the DB or manager first. Doing manager move might be considered first.

indromojo's picture

Hi Pete, thanks for the links,

for the fall back plan, it is as simple as plugged in the old SCSP & DBase server and then the agent will reconnect to the old one? or?

and is there any issue if the agent 5.2.4 suddenly connected to the 5.2.9 server?

AMoss's picture

I would move the db first, as described in the second half of this article:

(section begins with header 'Moving the Database to Another Instance')

The primary reason I suggest moving the db first is 5.2.9 is supported only on SQL 2005+.

Next I would migrate the SCSP manager(s) to connect to the 5.2.4 db on the new SQL server. (assuming the manager(s) are not on the same box as SQL). If the Manager(s) are on the box as SQL, just make sure and grab the server.xml and cert files from the old machine.  When you perform server install on the new machine, select the option for Tomcat only and it will prompt your for the location of the xml and server cert file.

If you manager was seperate of SQL, final steps are to upgrade the manger, then console, then agents.

Regarding your concern re: 5.2.4 agent on a 5.2.9 will be issues.

Best of luck!

Looking for real-time reporting and data visualization for your Symantec Security solutions?

Want to tune DCS/CSP like a master? Cut your tuning times by more than half!

indromojo's picture

Hi Amoss, thanks for your advice, i am currently testing pete's and your suggestion on the testing environment first