Jump to content

Migration to Server 2016


Recommended Posts

Hi there,

at the moment I have a very good ESET environment running. Now I want to change my server OS on a new Server with new IP.

Has someone a cooking recipe for me, so I can transfer all my settings (including the policies) to the new system? I have a standard installation with mySQL.

Thanks

Tom

Link to comment
Share on other sites

  • Administrators
Link to comment
Share on other sites

Thanks for the link Marcos. The Backup of my database worked, but while restoreing the database on the new server I receive the following errormessage:

C:\Windows\system32>SQLCMD.EXE -S Servername\ERASQL -d ERA_DB -E -Q "RESTORE DATABASE ERA_DB FROM DISK = N'C:\_install\DBBACKUP'"
Msg 3102, Level 16, State 1, Server Servername\ERASQL, Line 1
RESTORE cannot process database 'ERA_DB' because it is in use by this session. It is recommended that the master database be used when performing this operation.
Msg 3013, Level 16, State 1, Server Servername\ERASQL, Line 1
RESTORE DATABASE is terminating abnormally.

What is running wrong? As I can see the command looks good. Reboot does not solve the situation.

Link to comment
Share on other sites

Hello there,

you can try the restore command with a restore option as the following:
SQLCMD -S servername\ERASQL -d ERA_DB -E -Q "USE master RESTORE DATABASE ERA_DB FROM DISK ='c:\backup\file.bak' with replace"

assuming that the  backup file is locating in c:\backup\file.bak
it can be done without the USE master option as well. 
 

Link to comment
Share on other sites

Thanks Farah,

I did the command as you described. First I had a errormessage, the database is in use, bur after stopping the ESMC it worked.

But now I have the next problem:

The webconsole is starting, then I type my username and password. Login does not work, but I get an errormessage:

Login failed: Connection has failed with state 'Not connected'

Before I did the restore it worked with the usernam/password

What else can I do?

Thanks

Link to comment
Share on other sites

I do not know, what I have done wrong - but there was no solution for me after hours of unseccessful tries.

 

I have made the decision to install the ESMC new on the new server and switch client by client to the new system

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...