• This topic has 3 replies, 3 voices, and was last updated February 19, 2020 by Santhosh D.

Can we update SQL 2014 to SP3

  • Amir B
    February 17, 2020 04:33:59 PM

    We have been reviewing our systems OS and installed software to ensure they are running supported versions. We see that the Zerto application comes with SQL Server 2014 (Express). We have not updated to the lastest release of Zerto yet and are wondering if the latest Zerto release comes with an update to SQL, or whether we can install the SP 3 update ourselves to stay in compliance. Any assistance or suggestions would be appreciated.

    Santhosh D
    February 17, 2020 05:55:29 PM

    Hello,

    Mike from Zerto here.

    You would need to upgrade SQL manually. Please see the below steps:

    Note: This requires downtime for the ZVM and may require a restart of the ZVM VM.

    Steps to upgrade Microsoft SQL Server Express:

    • Stop all Zerto services and take a snapshot of the VM.
    • Download the Microsoft SQL Server Express SP3 64-bit installer for LocalDB (ENU\x64\SqlLocalDB.msi): https://www.microsoft.com/en-us/download/details.aspx?id=57473
    • After running the installer it will produce a warning: “A lower version of this product has been detected on your system. Would you like to upgrade your existing installation?”
    • Click ‘Yes’ to continue the installation of the new version.
    • Once the installer has completed, you may receive the message “You must restart your system for the configuration changes made to Microsoft SQL Server 2014 Express LocalDB to take effect. Click Yes to restart now or No if you plan to manually restart later.” Click ‘Yes’.
    • After rebooting the Microsoft SQL Server 2014 Express LocalDB version will be 12.3.6024.0MS SQL Server Express Upgrade
    • Log on to the ZVM GUI and verify that the environment is healthy. If there are any unexpected issues then collect logs using the Zerto Diagnostic application and contact Zerto Support for assistance. The snapshot taken before the upgrade can be used to revert to a known good state, after the collection and storage/upload of logs covering any unexpected issue.
    Lauren V
    February 19, 2020 05:05:35 PM

    Hello Mike,

     

    This is great! Thank you!  We have 2 Zerto servers.  I’m assuming we are stopping the services on 1 system, updating SQL, rebooting, logging into the GUI to ensure all is OK, and then performing the same steps on the 2nd.  Would that be accurate?  I want to ensure we aren’t breaking anything when the 1st system reboots and is using a different version of SQL than the other system.

     

    Thanks,

    Lauren

    Santhosh D
    February 19, 2020 05:18:04 PM

    Hello Lauren,

    Yes, that would be accurate.

The forum ‘Support Q & A’ is closed to new topics and replies.