25

I have two SQL Agent jobs which are scheduled to run at different intervals. The first job runs a full backup once a day. The second job runs transaction log backups every fifteen minutes.

As the database has grown, the full backup is taking longer than originally planned (even with compression). And I've noticed from my logs that the transaction log backups are now running at the same time.

Should I change the schedule of the transaction log backup so that doesn't run when the full backup is running? Does it matter?

1
  • as others mentioned no need to change your schedule and no conflict, even i prefer to have log backup during full back up because what if the full backup fails due to space constraint? And an Immediate failure at the time full backup, your log backup will save the day!
    – Biju jose
    Jun 1, 2018 at 4:12

3 Answers 3

28

As you can see in this table, there is no conflict between Full backup and Log backup. They can occur at same time, and, when log backup completes, log will not be cleaned until full backup (or diff backup) completes.

enter image description here

Not all administrative tasks are allowed to run concurrently. In the table below, a black circle indicates two operations that cannot run in a database at the same time.

References:

Concurrent Administrative Operations

1
  • 3
    That is one of those tables that you just want to save for later. Thanks for the link. +1 Aug 6, 2011 at 5:09
5

No, there is no need to do this.

0

No, it does not. There is no need to make any changes. The full database backup does not corrupt the transaction log and does not truncate it. Only when you make a transaction log backup the transaction log will be truncated.

2
  • 1
    Aren't you telling the same thing Alex_L posted a while ago?
    – dezso
    Nov 25, 2015 at 10:11
  • We have similar answers Nov 25, 2015 at 11:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.