|
数据库维护计划中同时做了完整备份计划和差异备份计划,完整备份计划正常执行,但是差异备份计划经常失败,只有再刚做完完整备份后做的差异备份才能正常,过了几天差异备份又不行了,现在的计划是每周日执行完整备份,每天执行差异备份,是不是完整备份的有效性需要设置的?过了一段时间差异备份就识别不到上一个完整备份了?所以差异备份失败?
下面是备份日志:
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 |
|