Home Forums SQL Server 2008 SQL Server Newbies How do I recover a db corrupted more than 1 full backup ago, and apply all subsequent diff backups??? RE: How do I recover a db corrupted more than 1 full backup ago, and apply all subsequent diff backups???

  • April 5, 2014 at 12:46 am

    #1703467

    Lynn Pettis (4/4/2014)

    Differential backups are tied to the full back taken prior to them. After restoring with norecovery the the full backup from day 1 and the last differential taken before the next full backup (norecovery) you then have to start restoring all the transaction log backups taken after that differential backup (with norecovery on all except the last transaction log backup).

    thanks for the quick reply Lynn,

    had thought to try the umpteen log file restore, however the sql error when trying a trans log restore of the first logfile created after last diff day1 (so; full, diff, log1) is:

    "...

    System.Data.SqlClient.SqlError: The log in this backup set terminates at LSN 2804703000000039200001, which is too early to apply to the database. A more recent log backup that includes LSN 2804992000000193600001 can be restored

    ..."

    yet none of the more recent logfiles work either.