Jump to content

Archived

This topic is now archived and is closed to further replies.

tmuster2k

Moving SQL Database to another server

Recommended Posts

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? 

Share this post


Link to post
Share on other sites

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? 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...