Jump to content
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? 

Edited by tmuster2k

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...