• Further to what Wayne has written:

    In order to use this full back-up to restore the datbase, we also need to apply the transaction log on top of the restore. This is required for all the transactions that were committed after the full backup reading ends.

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter