Jump to content

Heric.am

Members
  • Posts

    2
  • Joined

  • Last visited

Posts posted by Heric.am

  1. Hi Guys,

    I am planning to upgrade from ERA server of a client to the last version. He is using the ERA 6.1.444 now. Before beginning the procedure with him, I am testing in my virtual enviroment to check the behavioir of ERA.
    Well ... The procedure described at Eset web site is working fine using the task: Remote Administrator components upgrade, but I am really worried about how to perform the backup if this process fails there.
    There are couple problems that I am facing.
    The procedure that I am following says to export the certificates, and backup the database using this command: SQLCMD -S HOST \ ERASQL -q "BACKUP DATABASE ERA_DB TO DISK = N'BACKUPFILE '"
    Until there it's fine, but how about restore the backup?
    I attempted a scenario where the upgrade task fails. I installed the last version and tried to restore the database using the command SQLCMD.EXE -S HOST \ ERASQL -d ERA_DB -E -Q "RESTORE DATABASE ERA_DB FROM DISK = N'BACKUPFILE '" but it just does not work. I tried this other procedure to restore the backup
    sqlcmd
    use master;
    go
    retore database ERA_DB from disk = 'C: \ Backup \ eset';
    go
    The backup is restored after that, but after that, the ERA servisse does not work any more. That means that I can not restore a backup from an old version and restore it in a new version?
    I tried to restore the database using the old version of server, and it worked fine.

    But still there is another problem, how to import all certificates? I found the places to retore the certificate authority and server certificate, but how to restore the agent certificate?

    What would be the mean procedure to restore backups? Like... If I Lose my server

×
×
  • Create New...