• This topic has 1 reply, 2 voices, and was last updated November 9, 2018 by Ryan S.

Move MS SQL DB to New Win 2016 SQL Server

  • Ralph H
    August 10, 2018 12:43:19 AM

    we’re on a Win & SQL std 2008R2. our db is about 7 gb.  are there any migration instructions to move a zerto external SQL db to another external SQL db (new version)?  all I was able to find was, “Migrating the ZVM Database to SQL Server – Zerto Virtual Replication”, which is really a freeware, local install to an licensed external MS SQL db guide.  I should be able to just use this but wondered if there was some other instructions buried someplace?

    Ryan S
    November 9, 2018 04:51:51 PM

    Hi Ralph,

    Checking on this internally to see if there are other ways.
    Not sure if this would work in your scenario, but I have come across some ways in which people have attempted to migrate the ZVM application as outlined in the following steps:

    1. Prepare new VM for the ZVM (from now on it will be referred as VM2): See the documentation for minimum requirements
    2. Copy the ZVM installation file of the same version of the old VM to VM2
    3. Stop the ZVM services on the old VM
    4. Make a copy of the entire Zerto install directory and all its content on the old VM (on default this folder is named
      “Zerto Virtual Replication”). To save space, it is possible to leave out or delete old log files which are not relevant anymore. Those are found in “\Zerto Virtual Replication\logs”.
    5. Copy the above folder with all its content to a temp directory on VM2
    6. Change the IP address of the old VM to a different IP so it will not interfere with VM2, disconnect its network / power off the VM.
    7. On VM2 go to Control Panel -> Network and Internet and set its IP address to be the same as the old VM was.
    8. Execute the ZVM installer and complete the installation on VM2 with the same inputs like the ZVM was installed on the old VM
    9. Stop the ZVM services on VM2
    10. On VM2 replace the Zerto installation folder with the folder and content from step 5 (overwrite all files)
    11. Start the ZVM services on VM2
    12. Log on the ZVM GUI (from anywhere on the network) and validate the status of the VPGs and VRAs is OK.
    13. If all is OK, delete VM1

    Again, not sure if this is a viable solution and if it was I would certainly test it first, but maybe it’s a step in the right direction.

    Ryan

The forum ‘General Discussion’ is closed to new topics and replies.