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

Question about SEC database

Userheadspace

When we installed SEC/Sophos in our environment we installed the database locally, since then we have decide to migrate the DB to a central DB server, could anyone please point me to a KB article describing how to perform such an action.

thanks in advance

:48582


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

    Here are the steps I follow to move the database role from one server to another:

    Information:
    SEC 5.2.1 R2 in a domain (boom.local)


    Computers:
    DC: bkzdni8n3.boom.local
    Member1: clone1.boom.local
    Member2: clone2.boom.local

    Steps:
    Installed SEC 5.2.1 R2 on Member1 - accounts used: boom\db and boom\sum

    All in one install.

    Installed DB role of SEC 521 R2 on Member2

    Notes:
    Both computer has SQL Express 2008R2 as installed with SEC. Used boom\administrator for all tasks

    Stopped all the Sophos management services on Member1
    Ran:
    Databackuprestore.exe -action=Backup -datasourcetype=Database
    All 4 database backups are stored:
    \documents and settings\all users\application data\sophos\managementserver\backupdatabases

    Copied the 4 databases to Member2 to the directory:
    \documents and settings\all users\applicatio data\sophos\managementserver\backup\databases\


    Note: Had to create "\managementserver\backup\databases\"

    This is as per the migration guide: http://www.sophos.com/en-us/medialibrary/PDFs/documentation/sec_52_mgeng.pdf.

    Also created DataBackupRestore under the backup directory on Member2.

    Copied the following files and folders to the DataBackupRestore.
    -Metadata (entire folder along with its contents)
    -BackupRestore.proj
    -DataBackupRestore.exe
    -DataBackupRestore.exe.config
    -ResetUserMappings.sql
    -TBK.bat
    -TRS.bat

    On Member2 ran:
    DataBackupRestore -Action=Restore -DataSourceType=Database

    On Member1 uninstalled the database component from Add/Remove.
    On Member1 ran setup.exe
    Specified clone2\sophos as the new SQL instance
    Modify completed. Checked Connection string to be sure the database on Clone2 was in use.


    Regards,

    Jak

    :48600
Reply
  • 0

    Here are the steps I follow to move the database role from one server to another:

    Information:
    SEC 5.2.1 R2 in a domain (boom.local)


    Computers:
    DC: bkzdni8n3.boom.local
    Member1: clone1.boom.local
    Member2: clone2.boom.local

    Steps:
    Installed SEC 5.2.1 R2 on Member1 - accounts used: boom\db and boom\sum

    All in one install.

    Installed DB role of SEC 521 R2 on Member2

    Notes:
    Both computer has SQL Express 2008R2 as installed with SEC. Used boom\administrator for all tasks

    Stopped all the Sophos management services on Member1
    Ran:
    Databackuprestore.exe -action=Backup -datasourcetype=Database
    All 4 database backups are stored:
    \documents and settings\all users\application data\sophos\managementserver\backupdatabases

    Copied the 4 databases to Member2 to the directory:
    \documents and settings\all users\applicatio data\sophos\managementserver\backup\databases\


    Note: Had to create "\managementserver\backup\databases\"

    This is as per the migration guide: http://www.sophos.com/en-us/medialibrary/PDFs/documentation/sec_52_mgeng.pdf.

    Also created DataBackupRestore under the backup directory on Member2.

    Copied the following files and folders to the DataBackupRestore.
    -Metadata (entire folder along with its contents)
    -BackupRestore.proj
    -DataBackupRestore.exe
    -DataBackupRestore.exe.config
    -ResetUserMappings.sql
    -TBK.bat
    -TRS.bat

    On Member2 ran:
    DataBackupRestore -Action=Restore -DataSourceType=Database

    On Member1 uninstalled the database component from Add/Remove.
    On Member1 ran setup.exe
    Specified clone2\sophos as the new SQL instance
    Modify completed. Checked Connection string to be sure the database on Clone2 was in use.


    Regards,

    Jak

    :48600
Children
No Data