• Pretty much.

    The DB was in full recovery, any query you run will tell you that, just in the absence of a full backup there's nothing to base log backups on and hence the log doesn't get retained, until someone takes that full backup (often without any idea of the consequences)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass