• This topic has 2 replies, 2 voices, and was last updated November 18, 2019 by Carlos C.

Issues with SQL jobs

  • Carlos C
    September 29, 2019 04:15:26 PM

    hi guys

    it’s worth to ask even when it’s something SQL related but maybe someone already experienced it

    I have this customer 1.2 TB SQL VM we did a failover to Site B, VM stayed there for a day VM worked great in Site B, so we scheduled a failback and  everything when fine as well but next day customer found the SQL jobs scheduled to run every 10 seconds where running every 2 hours instead so customer had to re-create the SQL jobs and asked me about it

    has someone had similar experience with SQL?

    thanks

    John M
    November 18, 2019 07:35:04 PM

    Zerto doesn’t touch the OS of a VM by default.  If any scripting was run with the failover/failback that would change those settings, or someone changed the job schedule while the VM was running at site B (which would have replicated back to site A) would be the only assumed reason.

    Carlos C
    November 18, 2019 07:40:59 PM

    thanks it was this

    server started with UTC time and SQL took that time so all jobs were out dated when the task started

    so we had to set SQL service as manual and start the SQL service after server sync time with Active directory instead of UTC

You must be logged in to create new topics. Click here to login