Can not restore Differential SQL Server with error 2006

MSP360 Backup Backup SQL Server
1

Restore the full backup ok, but when try to restore differencial backups I get the next Error:This differential backup cannot be restored because the database has not been restored to the correct earlier state.
This is the log

2021-06-01 10:52:19,226 [SERV] [1] NOTICE - **********************************************************************************************************
2021-06-01 10:52:19,262 [SERV] [1] NOTICE - CloudBerry Backup for MS SQL Server Engine Started. Version: 7.1.0.206
2021-06-01 10:52:19,263 [SERV] [1] NOTICE - Plan: Restore plan on 01/06/2021 10:52:13 (aa3bcf14-6eb8-44c2-bb7d-49596e187966). Type: RestoreDatabasePlan. Start mode: Normal
2021-06-01 10:53:10,722 [SERV] [1] ERROR - Failed to restore database: NovaNet_Tools
CloudBerryLab.Backup.MSSQL.Exceptions.SqlErrorException
No se puede restaurar la copia de seguridad diferencial porque la base de datos no se ha restaurado al estado anterior correcto.
Fin anómalo de RESTORE DATABASE.

at BAL.b()
at BAl.A(BAe , SqlConnection , BAL , String , BAd , ICancelable )
at BAl.A(MSSQLRestoreType , String , String , Boolean , Boolean , Nullable1 , List1 , ICancelable )
at Cf.M()

2021-06-01 10:53:10,817 [PL] [1] ERROR - Failed to restore database; Code - 2006
2021-06-01 10:53:10,842 [PL] [1] ERROR - CBL2006: No se puede restaurar la copia de seguridad diferencial porque la base de datos no se ha restaurado al estado anterior correcto.
Fin anómalo de RESTORE DATABASE.

2021-06-01 10:53:10,855 [SERV] [1] NOTICE - =
2021-06-01 10:53:10,856 [SERV] [1] NOTICE - Starting (Running) / 00:00:50 /
2021-06-01 10:53:10,857 [SERV] [1] NOTICE - Total: (Total) / 00:00:50 / Downloaded: 139 MB Size on disk: 151 MB
2021-06-01 10:53:10,858 [SERV] [1] NOTICE - =
2021-06-01 10:53:10,859 [SERV] [1] NOTICE - Plan status: Fail. Elapsed time: 00:00:50.7587050. Version: 7.1.0.206
2021-06-01 10:53:10,881 [SERV] [1] NOTICE - Elapsed time: 00:00:51. Max memory usage: 136 MB. Processor time: 00:00:04. DB connection: 16 DB query: 23 Status report: 74
2021-06-01 10:53:10,883 [SERV] [1] NOTICE - IO stats: read bytes: 127639532, write bytes: 285666640, other bytes: 109537716, reads: 795, writes: 434, other ops: 10085
2021-06-01 10:53:10,895 [SERV] [1] NOTICE - Scanned: 2(151 MB). Uploaded: 2(151 MB). Failed: 0
2021-06-01 10:53:12,012 [SERV] [1] NOTICE - Plan finished. CloudBerry Backup for MS SQL Server. Version: 7.1.0.206

2

[reply=“Gustavo;d2208”] The Differential backup you are restoring does not belong with the Full backup you restored - is the most likely reason. Has anyone run any full backups on that database after the full backup, but before the differential backup? If so, that’s the reason. You would need to perform a COPY ONLY backup to prevent this issue.

You can check your msdb database to see what has been run on the database in question. I think you can check the database_backup_lsn column to see what set the backup belongs to. Run a query like this and change the database name as needed.

-- Last 1000 database backups performed SELECT TOP 1000 db.name "DatabaseName", bs.server_name "ServerName", bs.backup_set_id "BackupSetID", bs.name "Name", CASE bs.type WHEN 'D' THEN 'D-Database' WHEN 'I' THEN 'I-Differential' WHEN 'L' THEN 'L-Log' WHEN 'F' THEN 'F-File' WHEN 'G' THEN 'G-Differential' WHEN 'P' THEN 'P-Partial' WHEN 'Q' THEN 'Q-DifferentialPartial' ELSE bs.type END "Type", bs.backup_start_date "StartDate", DATEDIFF(mi, bs.backup_start_date, bs.backup_finish_date) "Duration(Min)", CAST(bs.backup_size/1024/1024 AS DECIMAL(11,2)) "Size(MB)", bs.user_name "UserName", CAST(bs.software_major_version AS VARCHAR(3)) + '.' + CAST(bs.software_minor_version AS VARCHAR(3)) + '.' + CAST(bs.software_build_version AS VARCHAR(5)) "SQLServerVersion" -- Uncomment the following line for additional Backup data ,bs.* FROM master.dbo.sysdatabases db INNER JOIN msdb.dbo.backupset bs ON bs.database_name = db.name WHERE bs.database_name = N'AdventureWorks' ORDER BY bs.backup_start_date desc;