Suppose I have configured full backup for every Sunday 1AM, differential backup every day at 1AM and log backups every hours from 12AM.

So, every day the differential and log backups collide at 1AM.

On Sunday all 3 backups collide at 1AM.

How does SQL server backups work under this scenario?


2 Answers 2


It's possible to take a full backup or a differential backup, and log backups concurrently of the same database. However, a full backup and differential backup cannot run concurrently as both will attempt to get a BULKOP_BACKUP_DB lock on the database. This means whichever receives the lock first gets to run first. The other will run after the previous finishes.

This can be exacerbated if the database belongs to an Availability Group and backups are being taken on multiple replicas.

You shouldn't have any issues, other than typical blocking that will happen for the duration of the blocking request. Whether or not this is truly a problem is up to you in your specific environment.


You could easily schedule your diffs to run Mon - Sat and that will potentially make the full backups faster. Diffs don't break the backup chain so in the case of restores you would still apply your full backup, then the last diff backup taken after the full you are applying (I call this the base), then any log backups taken after the last diff. You can also always skip restoring any diff at all and just restore the full and a whole lot of logs.

The reason cancelling the Sunday diff will make the Sunday full faster is it will reduce the extra load on the disk(s) and CPU (assuming you are compressing) from both backups occurring at the same time. Making database backups as fast as possible will benefit the database transaction log file as it can't be truncated until the full is finished.

It's normal for log backups to occur during full backups because full backups can take hours depending on the database size, disk speed, and network connection to the backup disk. Be sure to stripe them to make them even faster! You want your hourly log backup to continue to run during full backups so that in the case your full backup fails you can still meet your RPO.

Your Answer

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

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