Home Forums SQL Server 2008 SQL Server Newbies Can't restore transaction logs RE: Can't restore transaction logs

  • November 15, 2012 at 11:12 am

    #1559463

    anthony.green (11/15/2012)

    GilaMonster (11/15/2012)

    anthony.green (11/15/2012)

    Then you must be using an earlier full backup and not the current one from the latest 10:30 backup.

    This.

    A backup that starts at 10:30 and finishes at 11:30 may well need the tran log backup from 10:00 and the one from 11:00 (plus all later), but it could not need any from before that.

    Appreciate that but if the 10pm transaction log was still to recent to restore to the 10:30pm full backup then I assumed that the full backup is ealier in the transaction log chain, possibly from the night before

    I swear this reads like there are multiple full backups in the backup file because the backup file was not initialized. Maybe check to see how many full backups are actually in the full backup file just on the chance that this is the case?