Home Forums SQL Server 2008 SQL Server 2008 Administration This differential backup cannot be restored because the database has not been restored to the correct earlier state. RE: This differential backup cannot be restored because the database has not been restored to the correct earlier state.

  • Maybe I misunderstood, you're trying to apply the same differential that is matched to the first backup to a second, different backup? You can't do that. Differentials are tied directly to the last, full, backup. You can't restore a differential to any other full backup other than the last full one prior to the differential being run.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning