Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 14 replies
  • Subscribers 1 subscriber
  • Views 5558 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

Backup, Restore and Migrate Server Help

JKisner

For disaster recovery purposes, can anyone point me to the process for backing up and restoring the Endpoint Security and Control database server (version 4.0)?

Also, how would you go about migrating to a different server and still maintain connection with your endpoints and the database contents?

Thanks!

:959


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

    (This is in a test environment that I'm testing for disastery recovery)

    BackupDB.bat seems to work however I'm having issues with the restore process...RestoreDB.bat appears to have worked but clients cannot connect to database...

    Here's what I did:

    I ran backupdb on my initial install of the database.  Worked.

    Exported the Sophos Certificate Manager HKLM registery entry.

    Uninstalled Console and all MSSQL items.

    Restarted then deleted Sophos and MSSQL folders from Program Files folder.

    Reinstalled Sophos Console 4 and Database.

    Logged Off

    Logged in and closed console, which started automatically.

    Ran RestoreDB.bat - Successful.

    Imported Certificate Manager key - Successful.

    Opened console and got the following error:

    SQL error: 233
    ----- [outer exception] -----
       -- error: 0x80040300
       -- facility: Custom (Defined by the interface)

       at class ATL::CComPtr<struct IDispatch> __thiscall bl::CReusingManagementServiceClientBroker::logIn(void)
       at int __cdecl Run(int,enum bl::ConsoleType::Type)
       at int __stdcall wWinMain(struct HINSTANCE__ *,struct HINSTANCE__ *,wchar_t *,int)

    Hit ok and closed and reopened the console....Data is there from the restore process but endpoints cannot connect to the database.

    Any ideas what I did wrong or what I missed?

    :970
Reply
  • 0

    (This is in a test environment that I'm testing for disastery recovery)

    BackupDB.bat seems to work however I'm having issues with the restore process...RestoreDB.bat appears to have worked but clients cannot connect to database...

    Here's what I did:

    I ran backupdb on my initial install of the database.  Worked.

    Exported the Sophos Certificate Manager HKLM registery entry.

    Uninstalled Console and all MSSQL items.

    Restarted then deleted Sophos and MSSQL folders from Program Files folder.

    Reinstalled Sophos Console 4 and Database.

    Logged Off

    Logged in and closed console, which started automatically.

    Ran RestoreDB.bat - Successful.

    Imported Certificate Manager key - Successful.

    Opened console and got the following error:

    SQL error: 233
    ----- [outer exception] -----
       -- error: 0x80040300
       -- facility: Custom (Defined by the interface)

       at class ATL::CComPtr<struct IDispatch> __thiscall bl::CReusingManagementServiceClientBroker::logIn(void)
       at int __cdecl Run(int,enum bl::ConsoleType::Type)
       at int __stdcall wWinMain(struct HINSTANCE__ *,struct HINSTANCE__ *,wchar_t *,int)

    Hit ok and closed and reopened the console....Data is there from the restore process but endpoints cannot connect to the database.

    Any ideas what I did wrong or what I missed?

    :970
Children
No Data