mysql5资源共享

 找回密码
 立即注册
查看: 36|回复: 2

[MS-SQL Server] 【疑难】SQL server 差异备份失败

[复制链接]

1

主题

2

帖子

7

积分

新手上路

Rank: 1

积分
7
发表于 2019-7-15 12:01:19 | 显示全部楼层 |阅读模式
数据库维护计划中同时做了完整备份计划和差异备份计划,完整备份计划正常执行,但是差异备份计划经常失败,只有再刚做完完整备份后做的差异备份才能正常,过了几天差异备份又不行了,现在的计划是每周日执行完整备份,每天执行差异备份,是不是完整备份的有效性需要设置的?过了一段时间差异备份就识别不到上一个完整备份了?所以差异备份失败?
下面是备份日志:
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
回复

使用道具 举报

7

主题

531

帖子

1089

积分

金牌会员

Rank: 6Rank: 6

积分
1089
发表于 2019-7-15 23:33:31 | 显示全部楼层
请检查在完整备份之后到差异备份报错之间,是否有修改过数据库的恢复模式(recoverymode)?
如有,则会破坏数据库的备份链,导致差异备份失败.
回复

使用道具 举报

1

主题

2

帖子

7

积分

新手上路

Rank: 1

积分
7
 楼主| 发表于 2019-7-16 21:33:19 | 显示全部楼层
引用1楼唐诗三百首的回复:请检查在完整备份之后到差异备份报错之间,是否有修改过数据库的恢复模式(recoverymode)?
如有,则会破坏数据库的备份链,导致差异备份失败.没有修改过的
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

Archiver|手机版|小黑屋|mysql5.com Inc. ( 闽ICP备17002856号-1 )

GMT+8, 2019-10-23 00:19 , Processed in 0.057903 second(s), 18 queries .

Powered by MySQL5.com X3.4

© 2003-2019 MySQL5.com.

快速回复 返回顶部 返回列表