【疑难】SQL server 差异备份失败

crazy大白

数据库维护计划中同时做了完整备份计划和差异备份计划，完整备份计划正常执行，但是差异备份计划经常失败，只有再刚做完完整备份后做的差异备份才能正常，过了几天差异备份又不行了，现在的计划是每周日执行完整备份，每天执行差异备份，是不是完整备份的有效性需要设置的？过了一段时间差异备份就识别不到上一个完整备份了？所以差异备份失败？
下面是备份日志：
Microsoft(R)ServerMaintenanceUtility(Unicode)Version11.0.6251
Reportwasgeneratedon"127.0.0.1".
MaintenancePlan:DIFF_BACKUP
Duration:00:00:00
Status:Warning:Oneormoretasksfailed.
Details:
BackUpDatabase(Differential)(127.0.0.1)
BackupDatabaseon本地服务器连接
Databases:APP5,BASE5
Type:Differential
Appendexisting
Taskstart:2019-07-15T11:43:07.
Taskend:2019-07-15T11:43:07.
Failed:(-1073548784)Executingthequery"BACKUPDATABASE[BASE5]TODISK=N'F:\\bostalb..."failedwiththefollowingerror:"Cannotperformadifferentialbackupfordatabase"BASE5",becauseacurrentdatabasebackupdoesnotexist.PerformafulldatabasebackupbyreissuingBACKUPDATABASE,omittingtheWITHDIFFERENTIALoption.
BACKUPDATABASEisterminatingabnormally.".Possiblefailurereasons:Problemswiththequery,"ResultSet"propertynotsetcorrectly,parametersnotsetcorrectly,orconnectionnotestablishedcorrectly.

Command:BACKUPDATABASE[APP5]TODISK=N''F:\bostalbackup_everyday\APP5_backup_2019_07_15_114307_1998656.bak''WITHDIFFERENTIAL,NOFORMAT,NOINIT,NAME=N''APP5_backup_2019_07_15_114307_1998656'',SKIP,REWIND,NOUNLOAD,STATS=10

GO
BACKUPDATABASE[BASE5]TODISK=N''F:\bostalbackup_everyday\BASE5_backup_2019_07_15_114307_1998656.bak''WITHDIFFERENTIAL,NOFORMAT,NOINIT,NAME=N''BASE5_backup_2019_07_15_114307_1998656'',SKIP,REWIND,NOUNLOAD,STATS=10

GO


BackUpDatabase(Differential)(127.0.0.1)
BackupDatabaseon本地服务器连接
Databases:APP5,BASE5
Type:Differential
Appendexisting
Taskstart:2019-07-15T11:43:07.
Taskend:2019-07-15T11:43:07.
Failed:(-1073548784)Executingthequery"BACKUPDATABASE[APP5]TODISK=N'F:\\bostalba..."failedwiththefollowingerror:"Cannotperformadifferentialbackupfordatabase"APP5",becauseacurrentdatabasebackupdoesnotexist.PerformafulldatabasebackupbyreissuingBACKUPDATABASE,omittingtheWITHDIFFERENTIALoption.
BACKUPDATABASEisterminatingabnormally.".Possiblefailurereasons:Problemswiththequery,"ResultSet"propertynotsetcorrectly,parametersnotsetcorrectly,orconnectionnotestablishedcorrectly.

Command:BACKUPDATABASE[APP5]TODISK=N''F:\bostalbackup_everyday\APP5_backup_2019_07_15_114307_1998656.bak''WITHDIFFERENTIAL,NOFORMAT,NOINIT,NAME=N''APP5_backup_2019_07_15_114307_1998656'',SKIP,REWIND,NOUNLOAD,STATS=10

GO
BACKUPDATABASE[BASE5]TODISK=N''F:\bostalbackup_everyday\BASE5_backup_2019_07_15_114307_1998656.bak''WITHDIFFERENTIAL,NOFORMAT,NOINIT,NAME=N''BASE5_backup_2019_07_15_114307_1998656'',SKIP,REWIND,NOUNLOAD,STATS=10

GO

唐诗三百首

请检查在完整备份之后到差异备份报错之间,是否有修改过数据库的恢复模式(recoverymode)?
如有,则会破坏数据库的备份链,导致差异备份失败.

crazy大白

引用1楼唐诗三百首的回复:请检查在完整备份之后到差异备份报错之间,是否有修改过数据库的恢复模式(recoverymode)?
如有,则会破坏数据库的备份链,导致差异备份失败.没有修改过的