Query regarding upgrade from 9.5 to 10

Question

Hi, folks

I will be upgrading Sophos Enterprise Console this Friday. Last time I upgraded I had to back up the SQL database as per the recommendation of the upgrade advisor. I understand the upgrade advisor is built into the installer, and will follow the recommendations, but wanted to know if there is anything I can do to prepare for the installation and to guard against installation failure (as happened the last time I upgraded).

Any tips?

Thanks

Mark

This thread was automatically locked due to age.

jak · Accepted Answer

HI,

It's always worth taking a back up the "in use" SOPHOS database before starting, i.e.

SEC 4.0 - SOPHOS4 
 SEC 4.5 - SOPHOS45 
 SEC 4.7 - SOPHOS47

You can either use the backupdb.bat file provided by Sophos or just use the SQL tools. It is worth mentioning that the existing database is always left on ann upgrade so unless the upgrade completely takes out the SQL instance, you'll always have the previous database as it was prior to upgrade. So you can easily restore/retry.

Note: The new DBs created will be SOPHOS50 and SOPHOSPATCH.

Once backup is done, you can run the new installer on the DB machine to create the new databases mentioned above. As this just creates the 2 new blank databases, the existing SEC will still work. no risk here. The existing "Sophos DB Admins" group will be left.

Once you're ready to upgrade the Management Server machine you can run the installer on that machine. The new installer consists of a setup.exe (This makes all the checks and takes in all the parameters) and then runs the various MSIs passing the properties. During the install of the Server component, it will call the UpgradeDB.exe tool which will copy the data from your current live database, i.e. SOPHOS4x and move it into the new SOPHOS50.

The experience in my opinion is much smoother the way it's now componentised. I'd be suprised you have a problem.

The only thing I'm aware of to check is that you're not currently using a clear text password in the registry of the management server, http://www.sophos.com/support/knowledgebase/article/116519.html .

Otherwise I find: 
 http://www.sophos.com/support/knowledgebase/topics/1750 Is a good source of info on SEC 5 in regard to problems.

Regards, 
 Jak

:20085