• If this were an actual disaster recovery, then you would want a tail log backup. But that isn't the case here.

    You might want to read up on a few of the options here.

    http://msdn.microsoft.com/en-us/library/ms186858.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events