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.

  • The column Is_Copy_Only is backupset.

    But forget that comment, Diff backups cannot be made in a copy_only state

    http://msdn.microsoft.com/en-us/library/ms191495.aspx

    Your full backups though could be created as copy_only and therefore will not allow the diff to be restored.