• Hello!

    To me, the strategy that I have followed is:

    1. Get the database online as soon as possible - non-current data allowed

    2. Attempt to restore the most-recent data first - mostly OLTP systems need transactions from within the last month 80% of the time

    3. Attempt to restore the history data - the rest of the 80% data, used 20% of the time

    Going side-track here, but I find the above strategy useful in data cleanup projects as well.

    Have a great day!

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins