Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 8 replies
  • Subscribers 1 subscriber
  • Views 1482 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Query regarding upgrade from 9.5 to 10

Blood

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

:20081


This thread was automatically locked due to age.
Parents
  • 0

    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
Reply
  • 0

    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
Children
No Data