Open Forum

Backup causing connection errors

  • 1.  Backup causing connection errors

    Posted Mar 20, 2019 03:54 PM

    A month or so ago we Implemented Veeam Backup and Replication.   The replication was set to run every hour.  It would usually only take about 10 minutes to complete as it was only moving delta's from the last replication.  This was running perfect for several weeks, but we started getting the sql disconnect error from Dynamics clients.  I noticed the disconnects seemed to be on the hour, the same time Veeam is kicking off the hourly replication job.  So, I disabled the replication and wow!!!  Sql disconnect errors stopped.  So, what is happening?  When replication kicks off it starts a few second snapshot of the vm hfl-dynamics and ts-dynamics.  Even though this only takes a few seconds to complete, we are losing 1 packet and the network latency goes up to 40-50ms.  Once the snapshot is complete, everything settles back down. Has anyone tried to use Veeam Backup/Replication to replicate a Dynamics server to another location or server?

     

    Is there anything we can do to make it less sensitive to the latency and/or the dropped packets?



    ------------------------------
    Karen Keim
    Hello! Florida Destination Management Inc
    ------------------------------


  • 2.  RE: Backup causing connection errors

    SILVER CONTRIBUTOR
    Posted Mar 20, 2019 04:03 PM
    Karen,

    To clarify, is the Veeam replicate of the application/file server or of the SQL server?

    An hourly replicate of the application/file server might be a little aggressive, depending on your use case.  We do replicate our Dynamics application server on a nightly basis.

    An hourly replicate of the SQL server through Veeam might be better accomplished through native SQL backups.


    Drew

    ------------------------------
    Drew Skwiers-Koballa
    Director of IT
    Inside Edge CIS
    Eagan MN
    ------------------------------



  • 3.  RE: Backup causing connection errors

    Posted Mar 20, 2019 04:32 PM
    Thank you for the response.  We are also doing sql dumps so your solution would work.  We were just hoping for the least amount of data loss.  Essentially, if I change to night the problem would go away as no or few users would be online to be impacted.

    Having said all that.  Is Dynamics really that sensitive or is there something we could do to make it play better?

    Thanks

    ------------------------------
    Karen Keim
    Hello! Florida Destination Management Inc
    ------------------------------