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
