Can we update SQL 2014 to SP3

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.0
• 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.

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

Hello Lauren,

Yes, that would be accurate.