• yes, it's in full recovery and log is backed every 20 minutes. I checked this and log backups are happening fine every 20 min

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.