Home Forums SQL Server 2012 SQL 2012 - General Backup restore issue RE: Backup restore issue

  • May 21, 2015 at 9:02 am

    #1799722

    jitendra.padhiyar (5/21/2015)

    one more Tlog backup at 10.12 PM

    There's your problem.

    The full's fine, but a missing log backup will mean that you can't restore past that point. So unless you can find that log backup or have a full/diff after that time, you can't restore past 10:12 PM.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass