tmuster2k 22 Posted January 22, 2020 Share Posted January 22, 2020 I will be wanting to move my ESET SQL Express database to another server as I want all databases on one box. Is there a documented way of doing this? Would I need to do repair of ESMC Server service after moving database? Is SQL Management Studio needed for this process? Link to comment Share on other sites More sharing options...
santoso 7 Posted January 22, 2020 Share Posted January 22, 2020 We use this command to backup and restore database, no need to repair esmc https://help.eset.com/era_install/65/en-US/db_backup.html Link to comment Share on other sites More sharing options...
tmuster2k 22 Posted January 22, 2020 Author Share Posted January 22, 2020 (edited) I know the process on restoring dbase for same machine. I need to know how to move that database from a 2012 Server to a 2016 Sever that is hosting all my other SQL Express Databases? and then once moved how do I point my ESMC install that is on the 2012 server to the moved instance on the 2016 server? Edited January 22, 2020 by tmuster2k Link to comment Share on other sites More sharing options...
ESET Staff MartinK 383 Posted January 22, 2020 ESET Staff Share Posted January 22, 2020 Please check article Migration process for MS SQL Server in ESMC documentation. It should cover both parts of migration, i.e. moving data to new database server and also re-configuration of ESMC to connect to new database. Just be aware that configuration requirement for shared DB might be in conflict with current use, so please double check. Link to comment Share on other sites More sharing options...
Recommended Posts