Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 3474 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

Sophos Enterprise Console Upgrade/Install

syphuric1977

Hi,

Is there a way to restore a SOPHOS3 database to be used in SOPHOS45?

The upgrade from 3.1 -> 4.5 failed, and as such I had to completely uninstall SOPHOS and then complete a fresh install of 4.5.

I have a backup of the 3.1 database.  Is there a way that this can be easily restored/upgrade to be used in 4.5?  I have tried the restoredb.bat file which restores the DB successfully.  However, when running the upgradedb.exe -debug -sourceVersion=3/=4 I receive the following error:

09.02.2011 20:09:44 Error: DBI exception thrown Could not find stored procedure
'dbo.FromXTo4'.

Any pointers or suggestions would be greatly appreciated.

:8977


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

    It sounds as if you've used the restoredb.bat from version 4.5 to restore a sophos3 database (ie you have a file sophos45.mdf that is really a sophos3 database). This is the only reason I can think of that would explain the missing stored procedure.

    Instead you need to:

    1. Stop & disable the Sophos Management Service.
    2. Restore the sophos3.bak backup file to a sophos3 database:
      restoredb sophos3.bak server\instance sophos3
    3. Create a new, empty sophos45 database:
      cd /d "C:\Program Files (x86)\Sophos\Enterprise Console\DB"
      installdb server\instance
    4. Upgrade the sophos3 database to sophos45:
      cd /d "C:\Program Files(x86)\Sophos\Enterprise Console"
upgradedb -debug -sourceVersion=3
    5. Re-enable & restart the Sophos Management Service.

    Let us know if that works for you.

    Kindest regards,

    Tyler

    :9037
Reply
  • 0

    It sounds as if you've used the restoredb.bat from version 4.5 to restore a sophos3 database (ie you have a file sophos45.mdf that is really a sophos3 database). This is the only reason I can think of that would explain the missing stored procedure.

    Instead you need to:

    1. Stop & disable the Sophos Management Service.
    2. Restore the sophos3.bak backup file to a sophos3 database:
      restoredb sophos3.bak server\instance sophos3
    3. Create a new, empty sophos45 database:
      cd /d "C:\Program Files (x86)\Sophos\Enterprise Console\DB"
      installdb server\instance
    4. Upgrade the sophos3 database to sophos45:
      cd /d "C:\Program Files(x86)\Sophos\Enterprise Console"
upgradedb -debug -sourceVersion=3
    5. Re-enable & restart the Sophos Management Service.

    Let us know if that works for you.

    Kindest regards,

    Tyler

    :9037
Children
No Data