Will SQL Diff backup lock table?

allenyyzhouallenyyzhou Member Posts: 142
Recently, we faced a problem with sql diff backup. Our client is using NAV 2013 R2, we take sql diff backup everynight, sometimes some users still use NAV at that timing, so there will be table lock happens and the NAV Instance just restart automatically. We asked Microsoft, they said this is normal because sql backup will lock table. Just want to confirm here in Mibuso, does anyone faced the same problem before?

Best Answer


  • allenyyzhouallenyyzhou Member Posts: 142
    Thank you, Phenno

    I think I agree with you, backup should not cause deadlock. Last week I updated CU to the latest one, maybe that will solve my problem.
Sign In or Register to comment.