Differential backup error:
This differential backup cannot be restored because the database has not been restored to the correct earlier state.
Run the following to check why the backup is out of sequence.
select
s1.type,
s1.backup_start_date,
s1.backup_finish_date,
s1.first_lsn,
s1.last_lsn,s1.checkpoint_lsn,
s1.database_backup_lsn,
s2.physical_device_name
from msdb..backupset s1 inner join msdb..backupmediafamily s2
on s1.media_set_id = s2.media_set_id
where s1.database_name ='<QueryDatabase>' -- change to the Database that has concern
and s1.type in('D','L','I') -- sl.type in ('D','L') means full or Transaction Log backups (if 'I', Differential backups)
and s1.backup_start_date >= (select max(backup_start_date) from msdb..backupset where database_name ='<QueryDatabase>' and type ='D') -- change to the Database that has concern. Here is checking since the last full. You may need to modified the script a little bit to see more information.
order by s1.backup_start_date asc
Ensure that the differential backup is the correct one for the full backup.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center