使用TFS 2013 Update 2进行备份失败，“数据库中的日志损坏” [英] Backup failure with TFS 2013 Update 2, "log corruption in database"

问题描述

我们的预定备份（通过TFS管理控制台设置）失败。

our Scheduled backups (setup via the TFS Administration Console) are failing.

" C： \Program Files \ Microsoft SQL Server \ MSSQL11.MSSQLSERVER \ MSSQL \Log \ ERROR"报告：

_________________________________________________________________________________________________

"C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERROR" reports:
_________________________________________________________________________________________________

2016-11-15 10：54：40.81 spid74     备份检测到数据库Tfs_XYZConfiguration中的日志损坏。上下文是FirstSector。日志文件：2 'C：\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\Tfs_XYZConfigurationecac3b32-9bec-41c6-ad34-338d371c424c_log.ldf'
VLF的SeqNo：x63d5 VLFBase： x3f00000 LogBlockOffset：x3f19e00 SectorStatus：2 LogBlock.StartLsn.SeqNo：x49006b LogBlock.StartLsn.Blk：x650074尺寸：X77 PrevSize：X72

二○一六年十一月一十五日10：54：40.81备份  &NBSP ;  错误：3041，严重性：16，状态：1。

2016-11-15 10：54：40.81备份      BACKUP无法完成命令BACKUP LOG Tfs_XYZConfiguration。检查备份应用程序日志以获取详细消息。

2016-11-15 10:54:40.81 spid74      Backup detected log corruption in database Tfs_XYZConfiguration. Context is FirstSector. LogFile: 2 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\Tfs_XYZConfigurationecac3b32-9bec-41c6-ad34-338d371c424c_log.ldf' VLF SeqNo: x63d5 VLFBase: x3f00000 LogBlockOffset: x3f19e00 SectorStatus: 2 LogBlock.StartLsn.SeqNo: x49006b LogBlock.StartLsn.Blk: x650074 Size: x77 PrevSize: x72
2016-11-15 10:54:40.81 Backup      Error: 3041, Severity: 16, State: 1.
2016-11-15 10:54:40.81 Backup      BACKUP failed to complete the command BACKUP LOG Tfs_XYZConfiguration. Check the backup application log for detailed messages.

_________________________________________________________________________________________________

_________________________________________________________________________________________________

我看到的建议是更改 恢复模型到SIMPLE以允许事务日志清除，然后将其设置回FULL。

但我不确定这一点，因为TFS由多个数据库组成（tfs_configuration，tfs_collection，.. 。）。

A suggestion I've seen is to change the  Recovery Model to SIMPLE to allow the transaction log to clear, then setting it back to FULL.
But I'm not sure about this since TFS consists of more than one database (tfs_configuration, tfs_collection, ...).

任何有关解决此问题的最佳方法的指导都会很棒。

Any guidance on the best approach to resolving this issue would be great.

问候。

推荐答案

尝试验证您的磁盘子系统。你有其他的备份运行，例如在同时运行的文件系统中？

Try verify your disk subsystem. Do you have other backups running e.g. in filesystem that runs at the same time?

这篇关于使用TFS 2013 Update 2进行备份失败，“数据库中的日志损坏”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！