• sqlfriends (9/2/2015)


    That is good to know, so I can do another log backup after the previous diffential, and can still restored to 3:10?

    That really helps.

    Yes. Differentials are tied to the last full backup. Log backups, except the very first one after changing the database recovery model, are completely independent of any backup, full or differential. That's why they're so terribly important a part of disaster recovery.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning