Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 8 replies
  • Subscribers 0 subscribers
  • Views 24540 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

Enterprise Console Migration

RBGE

Hi all,

I've finally decided to bite the bullet and migrate Enterprise Console from an ancient Windows 2003 (32-bit) server to a slightly more up-to-date Windows 2008 R2 (64-bit) server, but am encountering a problem in this process.  The console is version 5.2.1 R2, and I'm following the migration guide linked to from http://www.sophos.com/en-us/support/knowledgebase/28276.aspx ( link leads to this document http://www.sophos.com/en-us/medialibrary/PDFs/documentation/sec_52_mgeng.pdf ).  The problem I'm encountering happens at point 4 of section 8 (on page 14) when attempting to restore the database to the new server.  The errors returned are in the attached text file, and contain an alarming amount of red text :smileyindifferent:

I notice it mentions the previous databases from 5.2.1 and before, which I'm not too concerned about as I just haven't removed them yet after the version upgrade, but it's not looking too promising for 5.2.1 R2 either.  Does anyone have any idea what I could be missing here?  I suspect it's something really simple which I've missed.

Many thanks for any help!

:49132


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

    Hi,

    If you have the 4 backup files, I would just restore them with restoredb.bak utility.

    C:\sec_52\ServerInstaller\DB\Core\restoredb.bat

    Usage:

    RestoreDB backup_file_path [server_name\instance_name] [database_name]

    Once done, then run the ResetUserMappings.sql file against each database, e.g.

    sqlcmd -E -S .\SOPHOS -d SOPHOS521  -i "C:\Program Files\Sophos\Enterprise Console\ResetUserMappings.sql"

    sqlcmd -E -S .\SOPHOS -d SOPHOSPATCH52  -i "C:\Program Files\Sophos\Enterprise Console\ResetUserMappings.sql"

    sqlcmd -E -S .\SOPHOS -d SOPHOSENC52  -i "C:\Program Files\Sophos\Enterprise Console\ResetUserMappings.sql"

    sqlcmd -E -S .\SOPHOS -d SophosSecurity  -i "C:\Program Files\Sophos\Enterprise Console\ResetUserMappings.sql"

    Database names per version: http://www.sophos.com/en-us/support/knowledgebase/17323.aspx

    Then carry on.

    Regards,

    Jak

    :49136
Reply
  • 0

    Hi,

    If you have the 4 backup files, I would just restore them with restoredb.bak utility.

    C:\sec_52\ServerInstaller\DB\Core\restoredb.bat

    Usage:

    RestoreDB backup_file_path [server_name\instance_name] [database_name]

    Once done, then run the ResetUserMappings.sql file against each database, e.g.

    sqlcmd -E -S .\SOPHOS -d SOPHOS521  -i "C:\Program Files\Sophos\Enterprise Console\ResetUserMappings.sql"

    sqlcmd -E -S .\SOPHOS -d SOPHOSPATCH52  -i "C:\Program Files\Sophos\Enterprise Console\ResetUserMappings.sql"

    sqlcmd -E -S .\SOPHOS -d SOPHOSENC52  -i "C:\Program Files\Sophos\Enterprise Console\ResetUserMappings.sql"

    sqlcmd -E -S .\SOPHOS -d SophosSecurity  -i "C:\Program Files\Sophos\Enterprise Console\ResetUserMappings.sql"

    Database names per version: http://www.sophos.com/en-us/support/knowledgebase/17323.aspx

    Then carry on.

    Regards,

    Jak

    :49136
Children
No Data
Unfiltered HTML