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.

  • August 20, 2012 at 10:46 am

    #1527737

    Grant Fritchey (8/20/2012)

    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.

    Grant,

    There was only one full backup for each of the Databases.

    I restored the complete backup then I attempted to restore the first differential and it failed. I performed a second differential and it failed as well. Did you notice the backup history that you asked for?

    I did this to a total of six Databases, 3 failed 3 sucessfull.

    I only performed the 2nd differential on the 1st Database that failed.

    I have 1 full backup then I have one differential for each of the other 6 databases.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/