• You should take Transaction log backup more often, However the frequency of Transaction log backup would be directly related to your RPO (Recovery Point Objective). Loosing 30 minutes of data in a high transaction environment doesn't sound good to me.

    I have RPO of 5 minutes, so here is what i do.

    1. Full backup at 01:00 AM

    2. Differential backups every Hour.

    3. Transnational log backup every 5 minutes.

    In case my database crash at 3:20 AM :

    1. Restore the full backup taken at 01:00 AM (No Recovery)

    2. Restore the differential backup taken at 03:00 Am (No Recovery)

    3. Restore all the transaction log backup post that in the exact sequence. (Last one with Recovery)

    If the database if not available then at max i will loos data worth 5 minutes. In case the database is available i can take a tail log backup and restore the data without any lose.

    Hope it helps..!!!

    Regards,
    Shafat Husain
    🙂
    And Your Lord Never Forgets...!! (64:19 -- Quran)