• Hi,

    you have three types of backups.

    full - which can be restored independent from any other backup

    differential - which is based on the recent full backup

    log - which is based on the recent differential or full backup

    In conclusion that mean:

    1. Restore the recent full backup

    2. Restore the recent differential backup after the before restored full backup - and forget all log backups before this differential backup

    3. Restore all log backups after the before restored differential backup in the timely order

    I hope that makes it clear enough. 😉

    [font="Arial"]Kind regards,

    Patrick Fiedler
    Consultant

    Fiedler SQL Consulting

    www.fiedler-sql-consulting.de
    [/font]