尝试在TFS中手动备份时备份失败。错误代码:TF400983完全备份作业失败 [英] Backup Failing when tried to Manual Backup in TFS. Error code: TF400983 Full Backup Job failed
问题描述
[信息 @ 13:19:36.102] =========================================== =========================
[信息 @ 13:19:36.102] Team Foundation Server管理日志
[信息 @ 13:19:36.102]版本 :11.0.61030.0
[信息 @ 13:19:36.102]日期时间:02/18/2017 18:49:36
[信息 @ 13:19:36.102]输入   :完整备份活动
[信息 @ 13:19:36.102]用户   :BNB_SYS-PC\BNB_SYS
[信息 @ 13:19:36.102]机器 :BNB_SYS-PC
[信息 @ 13:19:36.102]系统 :Microsoft Windows NT 6.1.7601 Service Pack 1(AMD64)
[信息 @ 13:19:36.102] =========================================== =========================
[信息 @ 13:19:36.102] IisInstaller = Iis75Installer
[信息 @ 13:19:36.102] IIS功能值:SharedLibraries = 1
[信息 @ 13:19:36.102] IIS功能值:ProcessModelLibraries = 1
[信息 @ 13:19:36.102] IIS功能值:CoreWebEngine = 1
[信息 @ 13:19:36.102] IIS功能值:W3SVC = 1
[信息 @ 13:19:36.102] IIS功能值:缓存= 1
[信息 @ 13:19:36.102] IIS功能值:CachingBase = 1
[信息 @ 13:19:36.102] IIS功能值:HttpCache = 1
[信息 @ 13:19:36.102] IIS功能值:HttpProtocol = 1
[信息 @ 13:19:36.102] IIS功能值:RequestFiltering = 1
[信息 @ 13:19:36.102] IIS功能值:CompressionBinaries = 1
[信息 @ 13:19:36.102] IIS特征值:HttpLoggingBinaries = 1
[信息 @ 13:19:36.102] IIS特征值:HttpTracingBinaries = 1
[信息 @ 13:19:36.102] IIS功能值:IPSecurityBinaries = 1
[信息 @ 13:19:36.102] IIS功能值:RequestFilteringBinaries = 1
[信息 @ 13:19:36.102] IIS功能值:WindowsAuthenticationBinaries = 1
[信息 @ 13:19:36.102] IIS功能值:StaticContent = 1
[信息 @ 13:19:36.102] IIS功能值:DefaultDocument = 1
[信息 @ 13:19:36.102] IIS功能值:DirectoryBrowse = 1
[信息 @ 13:19:36.102] IIS特征值:HttpErrors = 1
[信息 @ 13:19:36.102] IIS功能值:HttpRedirect = 1
[信息 @ 13:19:36.102] IIS功能值:NetFxExtensibility = 1
[信息 @ 13:19:36.102] IIS功能值:ASPNET = 1
[信息 @ 13:19:36.102] IIS功能值:ISAPIExtensions = 1
[信息 @ 13:19:36.102] IIS特征值:ISAPIFilter = 1
[信息 @ 13:19:36.102] IIS功能值:ServerSideInclude = 1
[信息 @ 13:19:36.102] IIS特征值:HttpLogging = 1
[信息 @ 13:19:36.102] IIS功能值:LoggingLibraries = 1
[信息 @ 13:19:36.102] IIS功能值:RequestMonitor = 1
[信息 @ 13:19:36.102] IIS特征值:HttpTracing = 1
[信息 @ 13:19:36.102] IIS功能值:CustomLogging = 1
[信息 @ 13:19:36.102] IIS功能值:WindowsAuthentication = 1
[信息 @ 13:19:36.102] IIS功能值:HttpCompressionStatic = 1
[信息 @ 13:19:36.102] IIS特征值:HttpCompressionDynamic = 1
[信息 @ 13:19:36.102] IIS功能值:ManagementConsole = 1
[信息 @ 13:19:36.102] IIS功能值:ManagementScriptingTools = 1
[信息 @ 13:19:36.102] IIS功能值:AdminService = 1
[信息 @ 13:19:36.102] IIS功能值:ProcessModel = 1
[信息 @ 13:19:36.102] IIS特征值:NetFxEnvironment = 1
[信息 @ 13:19:36.102] IIS功能值:WASConfigurationAPI = 1
[信息 @ 13:19:36.133]环境:BaseEnvironment
设置:
InstallPath:C:\Program Files \ microsoft Team Foundation Server 11.0 \
IsTfsExpress:False
ToolsPath:C:\Program Files \ Microsoft Microsoft Team Server 11.0 \工具
ApplicationTierPath:C:\Program Files \ Microsoft Office Team Server 11.0 \ Application Tier
< span style ="white-space:pre"> BuildTierPath:C:\Program Files\Microsoft Team Foundation Server 11.0 \工具
ProxyPath:C:\Program Files \ Microsoft Office Team Server 11.0 \版本控制代理
SetupUser:BNB_SYS-PC\BNB_SYS
WebServicePath:C:\Program Files \ Microsoft Office Team Server 11.0 \ Application Tier \ Web Services
LicenseEdition:PID_RANGE_MSDN
SystemTfsTemp:C:\ Windows\Temp \TFSTemp
SharePointInstallTemp:C:\ Windows \Temp \TFSTemp \WSSInstall
InstalledLanguages:System.Collections.Generic.List`1 [System.Int32]
InstalledLanguagesString:1033;
操作系统:
MachineName:BNB_SYS-PC
主机名:BNB_SYS-PC
IsClientOS:True
IsServerOS:False
跨度>我sDomainController:False
IsMachineInWorkgroup:True
IsMachineInDomain:False
IsHomeEdition:False
IsUnsupportedEdition:False
版本:Windows7
MajorVersion:6
MinorVersion:1
ProcessorCount:4
ServicePackMajor:1
ServicePackMinor:0
IsOSPostTfsRelease:False
VisibleMemoryMB:3494
AdjustedMemoryGB:3
Iis:
IsInstalled:True
PreviouslyFailedConfig:False
RequiredIisFeaturesInstalled:True
操作系统:
MachineName:BNB_SYS-PC
主机名:BNB_SYS -PC
IsClientOS:True
IsServerOS:False
IsDomainController:False
IsMachineInWorkgroup:True
IsMachineInDomain:False
IsHomeEdition:False
IsUnsupportedEdition:False
< span style ="white-space:pre"> 版本:Windows7
MajorV ersion:6
MinorVersion:1
ProcessorCount:4
ServicePackMajor:1
ServicePackMinor:0
IsOSPostTfsRelease:False
VisibleMemoryMB:3494
AdjustedMemoryGB:3
Sql:
SqlInstance 0:
名称:MSSQLSERVER
FullName:BNB_SYS-PC
版本:开发人员版
版本:10.50.1600.1
IsWow64:False
LCID:10 33
IsExpressEdition:False
IsFullEdition:True
IsSupported:True
IsSharePointSupported:True
IsUpgradable:False
WindowsServiceName:MSSQLSERVER
SqlInstance 1:
名称:SQLEXPRESS
FullName:BNB_SYS-PC \ SqlExpress
版本:Express Edition
版本:11.0.2100.60
IsWow64:False
LCID:1033
IsExpressEdition:True
IsFullEdition:False
IsSupported:True
< span style ="white-space:pre"> IsSharePointSupported:False
IsUpgradable:False
WindowsServiceName:MSSQL $ SQLEXPRESS
SqlInstance 2 :
名称:SQLSERVER
FullName:BNB_SYS-PC\sqlserver
版本:标准版
版本:10.50.1600.1
IsWow64:False
LCID:1033
IsExpressEdition:False
IsFullEdition:True
IsSup ported:True
IsSharePointSupported:True
IsUpgradable:False
WindowsServiceName:MSSQL $ SQLSERVER
PowerTools:
IsBackupToolConfigured:False
[信息 @ 13:19:36.149] IisInstaller = Iis75Installer
[信息 @ 13:19:36.149] IIS功能值:SharedLibraries = 1
[信息 @ 13:19:36.149] IIS功能值:ProcessModelLibraries = 1
[信息 @ 13:19:36.149] IIS特征值:CoreWebEngine = 1
[信息 @ 13:19:36.149] IIS特征值:W3SVC = 1
[信息 @ 13:19:36.149] IIS特征值:缓存= 1
[信息 @ 13:19:36.149] IIS特征值:CachingBase = 1
[信息 @ 13:19:36.149] IIS功能值:HttpCache = 1
[信息 @ 13:19:36.149] IIS功能值:HttpProtocol = 1
[信息 @ 13:19:36.149] IIS功能值:RequestFiltering = 1
[信息 @ 13:19:36.149] IIS功能值:CompressionBinaries = 1
[信息 @ 13:19:36.149] IIS特征值:HttpLoggingBinaries = 1
[信息 @ 13:19:36.149] IIS特征值:HttpTracingBinaries = 1
[信息 @ 13:19:36.149] IIS功能值:IPSecurityBinaries = 1
[信息 @ 13:19:36.149] IIS功能值:RequestFilteringBinaries = 1
[信息 @ 13:19:36.149] IIS功能值:WindowsAuthenticationBinaries = 1
[信息 @ 13:19:36.149] IIS功能值:StaticContent = 1
[信息 @ 13:19:36.149] IIS功能值:DefaultDocument = 1
[信息 @ 13:19:36.149] IIS功能值:DirectoryBrowse = 1
[信息 @ 13:19:36.149] IIS特征值:HttpErrors = 1
[信息 @ 13:19:36.149] IIS特征值:HttpRedirect = 1
[信息 @ 13:19:36.149] IIS功能值:NetFxExtensibility = 1
[信息 @ 13:19:36.149] IIS功能值:ASPNET = 1
[信息 @ 13:19:36.149] IIS特征值:ISAPIExtensions = 1
[信息 @ 13:19:36.149] IIS特征值:ISAPIFilter = 1
[信息 @ 13:19:36.149] IIS功能值:ServerSideInclude = 1
[信息 @ 13:19:36.149] IIS特征值:HttpLogging = 1
[信息 @ 13:19:36.149] IIS功能值:LoggingLibraries = 1
[信息 @ 13:19:36.149] IIS功能值:RequestMonitor = 1
[信息 @ 13:19:36.149] IIS特征值:HttpTracing = 1
[信息 @ 13:19:36.149] IIS功能值:CustomLogging = 1
[信息 @ 13:19:36.149] IIS功能值:WindowsAuthentication = 1
[信息 @ 13:19:36.149] IIS特征值:HttpCompressionStatic = 1
[信息 @ 13:19:36.149] IIS特征值:HttpCompressionDynamic = 1
[信息 @ 13:19:36.149] IIS功能值:ManagementConsole = 1
[信息 @ 13:19:36.149] IIS功能值:ManagementScriptingTools = 1
[信息 @ 13:19:36.149] IIS功能值:AdminService = 1
[信息 @ 13:19:36.149] IIS功能值:ProcessModel = 1
[信息 @ 13:19:36.149] IIS特征值:NetFxEnvironment = 1
[信息 @ 13:19:36.149] IIS特征值:WASConfigurationAPI = 1
[信息 @ 13:19:36.149]
[信息 @ 13:19:36.149] + - + - + - + - + - | FullBackupPlan :: GenerateVerifyPlan | + - + - + - + - + -
[信息 @ 13:19:36.211]
[信息 @ 13:19:36.211] - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - +
[信息 @ 13:19:36.211] Activity.ExecutePlan
[信息 @ 13:19:36.211] - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - +
[信息 @ 13:19:36.227] - ContainerTask(ProgressNode):验证计划备份任务
- VerifyDiskFreeSpace(VerifyNode):验证备份路径是否有可用空间
- VerifySystemIsNotBeingServiced(VerifyNode) :验证系统目前尚未提供服务
$
[信息 @ 13:19:36.227]
[信息 @ 13:19:36.227] + - + - + - + - + - |执行| + - + - + - + - + -
[信息 @ 13:19:36.227]
[信息 @ 13:19:36.227] + - + - + - + - + - |查看设置| + - + - + - + - + -
[信息 @ 13:19:36.227]
摘要章节
$
[信息 @ 13:19:36.227]
[信息 @ 13:19:36.227] + - + - + - + - + - |环境| + - + - + - + - + -
[信息 @ 13:19:36.227]环境:BaseEnvironment
设置:
InstallPath:C:\Program Files \ microsoft Team Foundation Server 11.0 \
IsTfsExpress:False
ToolsPath:C:\Program Files \ Microsoft Microsoft Team Server 11.0 \工具
ApplicationTierPath:C:\Program Files \ Microsoft Office Team Server 11.0 \ Application Tier
< span style ="white-space:pre"> BuildTierPath:C:\Program Files\Microsoft Team Foundation Server 11.0 \工具
ProxyPath:C:\Program Files \ Microsoft Office Team Server 11.0 \版本控制代理
SetupUser:BNB_SYS-PC\BNB_SYS
WebServicePath:C:\Program Files \ Microsoft Office Team Server 11.0 \ Application Tier \ Web Services
LicenseEdition:PID_RANGE_MSDN
SystemTfsTemp:C:\ Windows\Temp \TFSTemp
SharePointInstallTemp:C:\ Windows \Temp \TFSTemp \WSSInstall
InstalledLanguages:System.Collections.Generic.List`1 [System.Int32]
InstalledLanguagesString:1033;
操作系统:
MachineName:BNB_SYS-PC
主机名:BNB_SYS-PC
IsClientOS:True
IsServerOS:False
跨度>我sDomainController:False
IsMachineInWorkgroup:True
IsMachineInDomain:False
IsHomeEdition:False
IsUnsupportedEdition:False
版本:Windows7
MajorVersion:6
MinorVersion:1
ProcessorCount:4
ServicePackMajor:1
ServicePackMinor:0
IsOSPostTfsRelease:False
VisibleMemoryMB:3494
AdjustedMemoryGB:3
Iis:
IsInstalled:True
PreviouslyFailedConfig:False
RequiredIisFeaturesInstalled:True
操作系统:
MachineName:BNB_SYS-PC
主机名:BNB_SYS -PC
IsClientOS:True
IsServerOS:False
IsDomainController:False
IsMachineInWorkgroup:True
IsMachineInDomain:False
IsHomeEdition:False
IsUnsupportedEdition:False
< span style ="white-space:pre"> 版本:Windows7
MajorV ersion:6
MinorVersion:1
ProcessorCount:4
ServicePackMajor:1
ServicePackMinor:0
IsOSPostTfsRelease:False
VisibleMemoryMB:3494
AdjustedMemoryGB:3
Sql:
SqlInstance 0:
名称:MSSQLSERVER
FullName:BNB_SYS-PC
版本:开发人员版
版本:10.50.1600.1
IsWow64:False
LCID:10 33
IsExpressEdition:False
IsFullEdition:True
IsSupported:True
IsSharePointSupported:True
IsUpgradable:False
WindowsServiceName:MSSQLSERVER
SqlInstance 1:
名称:SQLEXPRESS
FullName:BNB_SYS-PC \ SqlExpress
版本:Express Edition
版本:11.0.2100.60
IsWow64:False
LCID:1033
IsExpressEdition:True
IsFullEdition:False
IsSupported:True
< span style ="white-space:pre"> IsSharePointSupported:False
IsUpgradable:False
WindowsServiceName:MSSQL $ SQLEXPRESS
SqlInstance 2 :
名称:SQLSERVER
FullName:BNB_SYS-PC\sqlserver
版本:标准版
版本:10.50.1600.1
IsWow64:False
LCID:1033
IsExpressEdition:False
IsFullEdition:True
IsSup ported:True
IsSharePointSupported:True
IsUpgradable:False
WindowsServiceName:MSSQL $ SQLSERVER
PowerTools:
IsBackupToolConfigured:False
[信息 @ 13:19:36.227]
[信息 @ 13:19:36.227] + - + - + - + - + - |配置计划| + - + - + - + - + -
[信息 @ 13:19:36.227] - ContainerTask(ProgressNode):验证计划备份任务
- VerifyDiskFreeSpace(VerifyNode):验证备份路径是否有可用空间
- VerifySystemIsNotBeingServiced(VerifyNode) :验证系统目前尚未提供服务
$
[信息 @ 13:19:36.227]
[信息 @ 13:19:36.227] + - + - + - + - + - |运行验证计划备份任务:验证计划备份任务| + - + - + - + - + -
[信息 @ 13:19:36.227]
[信息 @ 13:19:36.227] + - + - + - + - + - |验证计划备份任务| + - + - + - + - + -
[信息 @ 13:19:36.227]开始节点:CONTAINER
[信息 @ 13:19:36.227] NodePath:进度
[信息 @ 13:19:36.227]节点返回:忽略
[信息 @ 13:19:36.227]完成验证计划备份任务:忽略
[信息 @ 13:19:36.227] ------------------------------------------- ----------
[信息 @ 13:19:36.227]
[信息 @ 13:19:36.227] + - + - + - + - + - |运行VerifyDiskFreeSpace:验证备份路径是否有可用空间| + - + - + - + - + -
[信息 @ 13:19:36.227]
[信息 @ 13:19:36.227] + - + - + - + - + - |验证备份路径是否具有可用空间| + - + - + - + - + -
[信息 @ 13:19:36.227]开始节点:DISKFREESPACE
[信息 @ 13:19:36.227] NodePath:Progress / DISKFREESPACE
[信息 @ 13:19:36.227]验证\\BNB_SYS-PC\TFSBackup上的磁盘可用空间
[信息 @ 13:19:36.227]节点返回:成功
[信息 @ 13:19:36.227]完成VerifyDiskFreeSpace:成功
[信息 @ 13:19:36.227] ------------------------------------------- ----------
[信息 @ 13:19:36.227]
[信息 @ 13:19:36.227] + - + - + - + - + - |运行VerifyConfigIsNotBeingServiced:验证系统当前没有服务| + - + - + - + - + -
[信息 @ 13:19:36.227]
[信息 @ 13:19:36.227] + - + - + - + - + - |验证系统目前尚未提供服务| + - + - + - + - + -
[信息 @ 13:19:36.227]启动节点:VerifySystemIsNotBeingServiced
[信息 @ 13:19:36.227] NodePath:Progress / VerifySystemIsNotBeingServiced
[信息 @ 13:19:36.227]验证系统目前尚未提供服务
[信息 @ 13:19:36.227]检查配置数据库上的服务标记
[信息 @ 13:19:36.381]节点返回:成功
[信息 @ 13:19:36.381]已完成VerifyConfigIsNotBeingServiced:成功
[信息 @ 13:19:36.381] ------------------------------------------- ----------
[信息 @ 13:19:36.381]执行结果:
[信息 @ 13:19:36.381]总体结果:成功
[信息 @ 13:19:36.381]完成节点:2
[信息 @ 13:19:36.381]节点成功:2
[信息 @ 13:19:36.381]节点跳过:0
[信息 @ 13:19:36.381]有错误的节点:0
[信息 @ 13:19:36.381]有警告的节点:0
[信息 @ 13:19:36.381]错误信息数量:0
[信息 @ 13:19:36.381]警告信息数量:0
[信息 @ 13:19:36.381]信息消息数量:0
[信息 @ 13:19:36.385]
[信息 @ 13:19:36.385] - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - +
[信息 @ 13:19:36.385] Activity.ExecutePlan
[信息 @ 13:19:36.385] - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - +
[信息 @ 13:19:36.385] - ContainerTask(ProgressNode):完整备份计划
- GrantSqlPermissionToBackups (ConfigureNode,1413):授予备份路径的SQL权限
- PrepareDatabases(ConfigureNode,1402) ):准备数据库以进行同步备份
- TakeFullBackup(ConfigureNode,1411):完整备份
[信息 @ 13:19:36.385]
[信息 @ 13:19:36.385] + - + - + - + - + - |执行| + - + - + - + - + -
[信息 @ 13:19:36.385]
[信息 @ 13:19:36.385] + - + - + - + - + - |查看设置| + - + - + - + - + -
[信息 @ 13:19:36.385]
摘要章节
$
[信息 @ 13:19:36.385]
[信息 @ 13:19:36.385] + - + - + - + - + - |环境| + - + - + - + - + -
[信息 @ 13:19:36.386]环境:BaseEnvironment
设置:
InstallPath:C:\Program Files \ microsoft Team Foundation Server 11.0 \
IsTfsExpress:False
ToolsPath:C:\Program Files \ Microsoft Microsoft Team Server 11.0 \工具
ApplicationTierPath:C:\Program Files \ Microsoft Office Team Server 11.0 \ Application Tier
< span style ="white-space:pre"> BuildTierPath:C:\Program Files\Microsoft Team Foundation Server 11.0 \工具
ProxyPath:C:\Program Files \ Microsoft Office Team Server 11.0 \版本控制代理
SetupUser:BNB_SYS-PC\BNB_SYS
WebServicePath:C:\Program Files \ Microsoft Office Team Server 11.0 \ Application Tier \ Web Services
LicenseEdition:PID_RANGE_MSDN
SystemTfsTemp:C:\ Windows\Temp \TFSTemp
SharePointInstallTemp:C:\ Windows \Temp \TFSTemp \WSSInstall
InstalledLanguages:System.Collections.Generic.List`1 [System.Int32]
InstalledLanguagesString:1033;
操作系统:
MachineName:BNB_SYS-PC
主机名:BNB_SYS-PC
IsClientOS:True
IsServerOS:False
跨度>我sDomainController:False
IsMachineInWorkgroup:True
IsMachineInDomain:False
IsHomeEdition:False
IsUnsupportedEdition:False
版本:Windows7
MajorVersion:6
MinorVersion:1
ProcessorCount:4
ServicePackMajor:1
ServicePackMinor:0
IsOSPostTfsRelease:False
VisibleMemoryMB:3494
AdjustedMemoryGB:3
Iis:
IsInstalled:True
PreviouslyFailedConfig:False
RequiredIisFeaturesInstalled: True
OS:
$b $b MachineName: BNB_SYS-PC
HostName: BNB_SYS -PC
IsClientOS: True
IsServerOS: False
IsDomainController: False
IsMachineInWorkgroup: True
IsMachineInDomain: False
IsHomeEdition: False
IsUnsupportedEdition: False
< span style=\"white-space:pre\">Version: Windows7
MajorV ersion: 6
MinorVersion: 1
ProcessorCount: 4
ServicePackMajor: 1
ServicePackMinor: 0
IsOSPostTfsRelease: False
VisibleMemoryMB: 3494
AdjustedMemoryGB: 3
Sql:
SqlInstance 0:
Name: MSSQLSERVER
FullName: BNB_SYS-PC
Edition: Developer Edition
Version: 10.50.1600.1
IsWow64: False
LCID: 10 33
IsExpressEdition: False
IsFullEdition: True
IsSupported: True
IsSharePointSupported: True
IsUpgradable: False
WindowsServiceName: MSSQLSERVER
SqlInstance 1:
Name: SQLEXPRESS
FullName: BNB_SYS-PC\SqlExpress
Edition: Express Edition
Version: 11.0.2100.60
IsWow64: False
LCID: 1033
IsExpressEdition: True
IsFullEdition: False
IsSupported: True
IsSharePointSupported: False
IsUpgradable: False
WindowsServiceName: MSSQL$SQLEXPRESS
SqlInstance 2:
Name: SQLSERVER
FullName: BNB_SYS-PC\sqlserver
Edition: Standard Edition
Version: 10.50.1600.1
IsWow64: False
LCID: 1033
IsExpressEdition: False
IsFullEdition: True
IsSup ported: True
IsSharePointSupported: True
IsUpgradable: False
WindowsServiceName: MSSQL$SQLSERVER
PowerTools:
IsBackupToolConfigured: False
[Info @13:19:36.386]
[Info @13:19:36.386] +-+-+-+-+-| Configuration Plan |+-+-+-+-+-
[Info @13:19:36.386] - ContainerTask (ProgressNode) : Full Backup Plan
- GrantSqlPermissionToBackups (ConfigureNode, 1413) : Granting SQL permission to backup path
- PrepareDatabases (ConfigureNode, 1402) : Preparing databases for taking synchronized backups
- TakeFullBackup (ConfigureNode, 1411) : Taking full backups
[Info @13:19:36.386]
[Info @13:19:36.386] +-+-+-+-+-| Running Full Backup Plan: Full Backup Plan |+-+-+-+-+-
[Info @13:19:36.386]
[Info @13:19:36.386] +-+-+-+-+-| Full Backup Plan |+-+-+-+-+-
[Info @13:19:36.386] Starting Node: CONTAINER
[Info @13:19:36.386] NodePath : Progress
[Info @13:19:36.386] Node returned: Ignore
[Info @13:19:36.386] Completed Full Backup Plan: Ignore
[Info @13:19:36.386] -----------------------------------------------------
[Info @13:19:36.386]
[Info @13:19:36.386] +-+-+-+-+-| Running GrantSqlPermissionToBackups: Granting SQL permission to backup path |+-+-+-+-+-
[Info @13:19:36.386]
[Info @13:19:36.386] +-+-+-+-+-| Granting SQL permission to backup path |+-+-+-+-+-
[Info @13:19:36.386] Starting Node: SQLBACKUPPERMISSION
[Info @13:19:36.386] NodePath : Progress/SQLBACKUPPERMISSION
[Info @13:19:36.386] Grant SQL Server permission to backup files
[Info @13:19:36.387] Reading backup set information
[Info @13:19:36.388] Granting SQL Server permission
[Info @13:19:36.400] Granting account ’NT AUTHORITY\NETWORKSERVICE’ permissions to path ’’
[Warning@13:19:36.400] TF400976: SQL Server service account NT AUTHORITY\NETWORKSERVICE does not have the required permissions to create backups on the backup path
[Info @13:19:36.400] Node returned: Warning
[Warning@13:19:36.400] TF400976: SQL Server service account NT AUTHORITY\NETWORKSERVICE does not have the required permissions to create backups on the backup path
[Info @13:19:36.400] Completed GrantSqlPermissionToBackups: Warning
[Info @13:19:36.400] -----------------------------------------------------
[Info @13:19:36.400]
[Info @13:19:36.400] +-+-+-+-+-| Running PrepareDatabases: Preparing databases for taking synchronized backups |+-+-+-+-+-
[Info @13:19:36.400]
[Info @13:19:36.400] +-+-+-+-+-| Preparing databases for taking synchronized backups |+-+-+-+-+-
[Info @13:19:36.400] Starting Node: PrepareDatabases
[Info @13:19:36.400] NodePath : Progress/PrepareDatabases
[Info @13:19:36.460] Preparing databases for synchronized backups
[Info @13:19:36.460] Setting backup recovery model to Full
[Info @13:19:36.473] Creating marked transaction stored procedure
[Info @13:19:36.624] Done.
[Info @13:19:36.624] Node returned: Success
[Info @13:19:36.625] Completed PrepareDatabases: Success
[Info @13:19:36.625] -----------------------------------------------------
[Info @13:19:36.625]
[Info @13:19:36.625] +-+-+-+-+-| Running TakeFullBackup: Taking full backups |+-+-+-+-+-
[Info @13:19:36.625]
[Info @13:19:36.625] +-+-+-+-+-| Taking full backups |+-+-+-+-+-
[Info @13:19:36.625] Starting Node: TakeFullBackup
[Info @13:19:36.625] NodePath : Progress/TakeFullBackup
[Info @13:19:36.625] Taking full backups
[Info @13:19:36.625] Queue backup job
[Info @13:19:36.710] Queued job 94d6120f-b517-4832-a794-b5d0031855cb
[Info @13:19:36.710] Waiting for backup job to start
[Info @13:20:21.749] Waiting for backup job to finish
[Info @13:20:26.753] TF400983: Full Backup Job Failed
[Error @13:20:26.754] [18-02-2017 13:19:37] [Info] Full database backup job
[18-02-2017 13:19:37] [Info] Getting backup lock
[18-02-2017 13:19:37] [Info] Scanning configuration for new DBs
[18-02-2017 13:19:37] [Info] BackupSettings changed ? False
[18-02-2017 13:19:37] [Info] starting full backups
[18-02-2017 13:19:37] [Info] Taking Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244630730380F.bak
[18-02-2017 13:19:37] [Info] BACKUP DATABASE [Tfs_Configuration] TO DISK = N’\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244630730380F.bak’ WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:19:41] [Info] Backup Complete for database Tfs_Configuration
[18-02-2017 13:19:41] [Info] Finished Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244630730380F.bak
[18-02-2017 13:19:41] [Info] Taking Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_DefaultCollection filename:\\BNB_SYS-PC\TFSBackup\Tfs_ DefaultCollection_9859602244630730380F.bak
[18-02-2017 13:19:41] [Info] BACKUP DATABASE [Tfs_DefaultCollection] TO DISK = N’\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244630730380F.bak’ WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:20:02] [Info] Backup Complete for database Tfs_DefaultCollection
[18-02-2017 13:20:02] [Info] Finished Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_DefaultCollection filename:\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244630730380F.bak
[18-02-2017 13:20:02] [Info] Finished Full backup set 9859602244630730380
[18-02-2017 13:20:02] [Info] Marking TFS databases
[18-02-2017 13:20:02] [Info] Executing on Tfs_DefaultCollection: BEGIN
DECLARE @text AS varchar(8000)
SELECT @text=’exec prc_TfsSetTransactionLogM ark TfsMarkTfpt’
EXECUTE (@text)
END
[18-02-2017 13:20:02] [Info] Executing on Tfs_Configuration: BEGIN
DECLARE @text AS varchar(8000)
SELECT @text=’exec prc_TfsSetTransactionLogMark TfsMarkTfpt’
EXECUTE (@text)
END
[18-02-2017 13:20:02] [Info] Starting transactional backups
[18-02-2017 13:20:02] [Info] Database Tfs_DefaultCollection parent set is 9859602244630730380
[18-02-2017 13:20:02] [Info] Starting Transactional backup server:BNB_SYS-PC\SqlExpress database:Tfs_DefaultCollection filename:\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244883074813L.trn
[18-02-2017 13:20:02] [Info] BACKUP LOG [Tfs_DefaultCollection] TO DISK = N’\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_ 9859602244883074813L.trn’ WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:20:20] [Error]
Exception Message: BACKUP detected corruption in the database log. Check the errorlog for more information.
BACKUP LOG is terminating abnormally. (type SqlException)
SQL Exception Class: 16
SQL Exception Number: 3049
SQL Exception Procedure:
SQL Exception Line Number: 1
SQL Exception Server: BNB_SYS-PC\SqlExpress
SQL Exception State: 1
SQL Error(s):
SQL Error[1]: System.Data.SqlClient.SqlError: BACKUP LOG is terminating abnormally.
&NBSP; Class: 16
&NBSP; Number: 3013
&NBSP; Server: BNB_SYS-PC\SqlExpress
&NBSP; Source: .Net SqlClient Data Provider
&NBSP; State: 1
&NBSP; Procedure:
&NBSP; Line Number: 1
Exception Data Dictionary:
HelpLink.ProdName = Microsoft SQL Server
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = 3049
HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476
Exception Stack Trace: at Microsoft.TeamFoundation.Admin.SqlDatabaseBackupRestoreComponent.Execute(String sqlStatement)
at Microsoft.TeamFoundation.Admin.SqlDatabaseBackup.Backup(String connectionString)
at Microsoft.TeamFoundation.Admin.Jobs.DatabaseBackupJob.TakeTransactionalBackupOfSingleDatabase(TeamFoundationRequestContext requestContext, String dataSource, String databaseName, String logFileName, ITFLogger logger)
at Microsoft.TeamFoundation.Admin.Jobs.DatabaseBackupJob.TakeTransactionalBackups(TeamFoundationRequestContext requestContext, BackupSettings settings, ITFLogger logger)
[18-02-2017 13:20:20] [Info] Database Tfs_Configuration parent set is 9859602244630730380
[18-02-2017 13:20:20] [Info] Starting Transactional backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244883074813L.trn
[18-02-2017 13:20:20] [Info] BACKUP LOG [Tfs_Configuration] TO DISK = N’\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244883074813L.trn’ WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:20:21] [Info] Backup Complete for database Tfs_Configuration
[18-02-2017 13:20:21] [Info] Completed Transactional backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\T FSBackup\Tfs_Configuration_9859602244883074813L.trn
[18-02-2017 13:20:21] [Info] Finished Transactional backup set 9859602244883074813
[18-02-2017 13:20:21] [Info] Full Backups Failed
[Info @13:20:26.754] Node returned: Error
[Error @13:20:26.756] [18-02-2017 13:19:37] [Info] Full database backup job
[18-02-2017 13:19:37] [Info] Getting backup lock
[18-02-2017 13:19:37] [Info] Scanning configuration for new DBs
[18-02-2017 13:19:37] [Info] BackupSettings changed ? False
[18-02-2017 13:19:37] [Info] starting full backups
[18-02-2017 13:19:37] [Info] Taking Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244630730380F.bak
[18-02-2017 13:19:37] [Info] BACKUP DATABASE [Tfs_Configuration] TO DISK = N’\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244630730380F.bak’ WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:19:41] [Info] Backup Complete for database Tfs_Configuration
[18-02-2017 13:19:41] [Info] Finished Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244630730380F.bak
[18-02-2017 13:19:41] [Info] Taking Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_DefaultCollection filename:\\BNB_SYS-PC\TFSBackup\Tfs_ DefaultCollection_9859602244630730380F.bak
[18-02-2017 13:19:41] [Info] BACKUP DATABASE [Tfs_DefaultCollection] TO DISK = N’\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244630730380F.bak’ WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:20:02] [Info] Backup Complete for database Tfs_DefaultCollection
[18-02-2017 13:20:02] [Info] Finished Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_DefaultCollection filename:\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244630730380F.bak
[18-02-2017 13:20:02] [Info] Finished Full backup set 9859602244630730380
[18-02-2017 13:20:02] [Info] Marking TFS databases
[18-02-2017 13:20:02] [Info] Executing on Tfs_DefaultCollection: BEGIN
DECLARE @text AS varchar(8000)
SELECT @text=’exec prc_TfsSetTransactionLogM ark TfsMarkTfpt’
EXECUTE (@text)
END
[18-02-2017 13:20:02] [Info] Executing on Tfs_Configuration: BEGIN
DECLARE @text AS varchar(8000)
SELECT @text=’exec prc_TfsSetTransactionLogMark TfsMarkTfpt’
EXECUTE (@text)
END
[18-02-2017 13:20:02] [Info] Starting transactional backups
[18-02-2017 13:20:02] [Info] Database Tfs_DefaultCollection parent set is 9859602244630730380
[18-02-2017 13:20:02] [Info] Starting Transactional backup server:BNB_SYS-PC\SqlExpress database:Tfs_DefaultCollection filename:\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244883074813L.trn
[18-02-2017 13:20:02] [Info] BACKUP LOG [Tfs_DefaultCollection] TO DISK = N’\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_ 9859602244883074813L.trn’ WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:20:20] [Error]
Exception Message: BACKUP detected corruption in the database log. Check the errorlog for more information.
BACKUP LOG is terminating abnormally. (type SqlException)
SQL Exception Class: 16
SQL Exception Number: 3049
SQL Exception Procedure:
SQL Exception Line Number: 1
SQL Exception Server: BNB_SYS-PC\SqlExpress
SQL Exception State: 1
SQL Error(s):
SQL Error[1]: System.Data.SqlClient.SqlError: BACKUP LOG is terminating abnormally.
&NBSP; Class: 16
&NBSP; Number: 3013
&NBSP; Server: BNB_SYS-PC\SqlExpress
&NBSP; Source: .Net SqlClient Data Provider
&NBSP; State: 1
&NBSP; Procedure:
&NBSP; Line Number: 1
Exception Data Dictionary:
HelpLink.ProdName = Microsoft SQL Server
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = 3049
HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476
Exception Stack Trace: at Microsoft.TeamFoundation.Admin.SqlDatabaseBackupRestoreComponent.Execute(String sqlStatement)
at Microsoft.TeamFoundation.Admin.SqlDatabaseBackup.Backup(String connectionString)
at Microsoft.TeamFoundation.Admin.Jobs.DatabaseBackupJob.TakeTransactionalBackupOfSingleDatabase(TeamFoundationRequestContext requestContext, String dataSource, String databaseName, String logFileName, ITFLogger logger)
at Microsoft.TeamFoundation.Admin.Jobs.DatabaseBackupJob.TakeTransactionalBackups(TeamFoundationRequestContext requestContext, BackupSettings settings, ITFLogger logger)
[18-02-2017 13:20:20] [Info] Database Tfs_Configuration parent set is 9859602244630730380
[18-02-2017 13:20:20] [Info] Starting Transactional backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244883074813L.trn
[18-02-2017 13:20:20] [Info] BACKUP LOG [Tfs_Configuration] TO DISK = N’\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244883074813L.trn’ WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:20:21] [Info] Backup Complete for database Tfs_Configuration
[18-02-2017 13:20:21] [Info] Completed Transactional backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\T FSBackup\Tfs_Configuration_9859602244883074813L.trn
[18-02-2017 13:20:21] [Info] Finished Transactional backup set 9859602244883074813
[18-02-2017 13:20:21] [Info] Full Backups Failed
[Info @13:20:26.757] Completed TakeFullBackup: Error
[Info @13:20:26.757] -----------------------------------------------------
[Info @13:20:26.757] Execution results:
[Info @13:20:26.757] Overall result: Failure, Issues
[Info @13:20:26.757] Nodes completed: 3
[Info @13:20:26.757] Nodes succeeded: 1
[Info @13:20:26.757] Nodes skipped: 0
[Info @13:20:26.757] Nodes with errors: 1
[Info @13:20:26.757] Nodes with warnings: 1
[Info @13:20:26.757] Number of error messages: 1
[Info @13:20:26.757] Number of warning messages: 1
[Info @13:20:26.757] Number of info messages: 0
[Error @13:20:26.759] Activity failed.
[Info @13:20:26.759] Activity failed and there is no handling of the failure such as rollback
[Info @13:19:36.102] ====================================================================
[Info @13:19:36.102] Team Foundation Server Administration Log
[Info @13:19:36.102] Version : 11.0.61030.0
[Info @13:19:36.102] DateTime : 02/18/2017 18:49:36
[Info @13:19:36.102] Type : Full Backup Activity
[Info @13:19:36.102] User : BNB_SYS-PC\BNB_SYS
[Info @13:19:36.102] Machine : BNB_SYS-PC
[Info @13:19:36.102] System : Microsoft Windows NT 6.1.7601 Service Pack 1 (AMD64)
[Info @13:19:36.102] ====================================================================
[Info @13:19:36.102] IisInstaller=Iis75Installer
[Info @13:19:36.102] IIS Feature value: SharedLibraries=1
[Info @13:19:36.102] IIS Feature value: ProcessModelLibraries=1
[Info @13:19:36.102] IIS Feature value: CoreWebEngine=1
[Info @13:19:36.102] IIS Feature value: W3SVC=1
[Info @13:19:36.102] IIS Feature value: Caching=1
[Info @13:19:36.102] IIS Feature value: CachingBase=1
[Info @13:19:36.102] IIS Feature value: HttpCache=1
[Info @13:19:36.102] IIS Feature value: HttpProtocol=1
[Info @13:19:36.102] IIS Feature value: RequestFiltering=1
[Info @13:19:36.102] IIS Feature value: CompressionBinaries=1
[Info @13:19:36.102] IIS Feature value: HttpLoggingBinaries=1
[Info @13:19:36.102] IIS Feature value: HttpTracingBinaries=1
[Info @13:19:36.102] IIS Feature value: IPSecurityBinaries=1
[Info @13:19:36.102] IIS Feature value: RequestFilteringBinaries=1
[Info @13:19:36.102] IIS Feature value: WindowsAuthenticationBinaries=1
[Info @13:19:36.102] IIS Feature value: StaticContent=1
[Info @13:19:36.102] IIS Feature value: DefaultDocument=1
[Info @13:19:36.102] IIS Feature value: DirectoryBrowse=1
[Info @13:19:36.102] IIS Feature value: HttpErrors=1
[Info @13:19:36.102] IIS Feature value: HttpRedirect=1
[Info @13:19:36.102] IIS Feature value: NetFxExtensibility=1
[Info @13:19:36.102] IIS Feature value: ASPNET=1
[Info @13:19:36.102] IIS Feature value: ISAPIExtensions=1
[Info @13:19:36.102] IIS Feature value: ISAPIFilter=1
[Info @13:19:36.102] IIS Feature value: ServerSideInclude=1
[Info @13:19:36.102] IIS Feature value: HttpLogging=1
[Info @13:19:36.102] IIS Feature value: LoggingLibraries=1
[Info @13:19:36.102] IIS Feature value: RequestMonitor=1
[Info @13:19:36.102] IIS Feature value: HttpTracing=1
[Info @13:19:36.102] IIS Feature value: CustomLogging=1
[Info @13:19:36.102] IIS Feature value: WindowsAuthentication=1
[Info @13:19:36.102] IIS Feature value: HttpCompressionStatic=1
[Info @13:19:36.102] IIS Feature value: HttpCompressionDynamic=1
[Info @13:19:36.102] IIS Feature value: ManagementConsole=1
[Info @13:19:36.102] IIS Feature value: ManagementScriptingTools=1
[Info @13:19:36.102] IIS Feature value: AdminService=1
[Info @13:19:36.102] IIS Feature value: ProcessModel=1
[Info @13:19:36.102] IIS Feature value: NetFxEnvironment=1
[Info @13:19:36.102] IIS Feature value: WASConfigurationAPI=1
[Info @13:19:36.133] Environment: BaseEnvironment
Setup:
InstallPath: C:\Program Files\Microsoft Team Foundation Server 11.0\
IsTfsExpress: False
ToolsPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Tools
ApplicationTierPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Application Tier
BuildTierPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Tools
ProxyPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Version Control Proxy
SetupUser: BNB_SYS-PC\BNB_SYS
WebServicePath: C:\Program Files\Microsoft Team Foundation Server 11.0\Application Tier\Web Services
LicenseEdition: PID_RANGE_MSDN
SystemTfsTemp: C:\Windows\Temp\TFSTemp
SharePointInstallTemp: C:\Windows\Temp\TFSTemp\WSSInstall
InstalledLanguages: System.Collections.Generic.List`1[System.Int32]
InstalledLanguagesString: 1033;
OS:
MachineName: BNB_SYS-PC
HostName: BNB_SYS-PC
IsClientOS: True
IsServerOS: False
IsDomainController: False
IsMachineInWorkgroup: True
IsMachineInDomain: False
IsHomeEdition: False
IsUnsupportedEdition: False
Version: Windows7
MajorVersion: 6
MinorVersion: 1
ProcessorCount: 4
ServicePackMajor: 1
ServicePackMinor: 0
IsOSPostTfsRelease: False
VisibleMemoryMB: 3494
AdjustedMemoryGB: 3
Iis:
IsInstalled: True
PreviouslyFailedConfig: False
RequiredIisFeaturesInstalled: True
OS:
MachineName: BNB_SYS-PC
HostName: BNB_SYS-PC
IsClientOS: True
IsServerOS: False
IsDomainController: False
IsMachineInWorkgroup: True
IsMachineInDomain: False
IsHomeEdition: False
IsUnsupportedEdition: False
Version: Windows7
MajorVersion: 6
MinorVersion: 1
ProcessorCount: 4
ServicePackMajor: 1
ServicePackMinor: 0
IsOSPostTfsRelease: False
VisibleMemoryMB: 3494
AdjustedMemoryGB: 3
Sql:
SqlInstance 0:
Name: MSSQLSERVER
FullName: BNB_SYS-PC
Edition: Developer Edition
Version: 10.50.1600.1
IsWow64: False
LCID: 1033
IsExpressEdition: False
IsFullEdition: True
IsSupported: True
IsSharePointSupported: True
IsUpgradable: False
WindowsServiceName: MSSQLSERVER
SqlInstance 1:
Name: SQLEXPRESS
FullName: BNB_SYS-PC\SqlExpress
Edition: Express Edition
Version: 11.0.2100.60
IsWow64: False
LCID: 1033
IsExpressEdition: True
IsFullEdition: False
IsSupported: True
IsSharePointSupported: False
IsUpgradable: False
WindowsServiceName: MSSQL$SQLEXPRESS
SqlInstance 2:
Name: SQLSERVER
FullName: BNB_SYS-PC\sqlserver
Edition: Standard Edition
Version: 10.50.1600.1
IsWow64: False
LCID: 1033
IsExpressEdition: False
IsFullEdition: True
IsSupported: True
IsSharePointSupported: True
IsUpgradable: False
WindowsServiceName: MSSQL$SQLSERVER
PowerTools:
IsBackupToolConfigured: False
[Info @13:19:36.149] IisInstaller=Iis75Installer
[Info @13:19:36.149] IIS Feature value: SharedLibraries=1
[Info @13:19:36.149] IIS Feature value: ProcessModelLibraries=1
[Info @13:19:36.149] IIS Feature value: CoreWebEngine=1
[Info @13:19:36.149] IIS Feature value: W3SVC=1
[Info @13:19:36.149] IIS Feature value: Caching=1
[Info @13:19:36.149] IIS Feature value: CachingBase=1
[Info @13:19:36.149] IIS Feature value: HttpCache=1
[Info @13:19:36.149] IIS Feature value: HttpProtocol=1
[Info @13:19:36.149] IIS Feature value: RequestFiltering=1
[Info @13:19:36.149] IIS Feature value: CompressionBinaries=1
[Info @13:19:36.149] IIS Feature value: HttpLoggingBinaries=1
[Info @13:19:36.149] IIS Feature value: HttpTracingBinaries=1
[Info @13:19:36.149] IIS Feature value: IPSecurityBinaries=1
[Info @13:19:36.149] IIS Feature value: RequestFilteringBinaries=1
[Info @13:19:36.149] IIS Feature value: WindowsAuthenticationBinaries=1
[Info @13:19:36.149] IIS Feature value: StaticContent=1
[Info @13:19:36.149] IIS Feature value: DefaultDocument=1
[Info @13:19:36.149] IIS Feature value: DirectoryBrowse=1
[Info @13:19:36.149] IIS Feature value: HttpErrors=1
[Info @13:19:36.149] IIS Feature value: HttpRedirect=1
[Info @13:19:36.149] IIS Feature value: NetFxExtensibility=1
[Info @13:19:36.149] IIS Feature value: ASPNET=1
[Info @13:19:36.149] IIS Feature value: ISAPIExtensions=1
[Info @13:19:36.149] IIS Feature value: ISAPIFilter=1
[Info @13:19:36.149] IIS Feature value: ServerSideInclude=1
[Info @13:19:36.149] IIS Feature value: HttpLogging=1
[Info @13:19:36.149] IIS Feature value: LoggingLibraries=1
[Info @13:19:36.149] IIS Feature value: RequestMonitor=1
[Info @13:19:36.149] IIS Feature value: HttpTracing=1
[Info @13:19:36.149] IIS Feature value: CustomLogging=1
[Info @13:19:36.149] IIS Feature value: WindowsAuthentication=1
[Info @13:19:36.149] IIS Feature value: HttpCompressionStatic=1
[Info @13:19:36.149] IIS Feature value: HttpCompressionDynamic=1
[Info @13:19:36.149] IIS Feature value: ManagementConsole=1
[Info @13:19:36.149] IIS Feature value: ManagementScriptingTools=1
[Info @13:19:36.149] IIS Feature value: AdminService=1
[Info @13:19:36.149] IIS Feature value: ProcessModel=1
[Info @13:19:36.149] IIS Feature value: NetFxEnvironment=1
[Info @13:19:36.149] IIS Feature value: WASConfigurationAPI=1
[Info @13:19:36.149]
[Info @13:19:36.149] +-+-+-+-+-| FullBackupPlan::GenerateVerifyPlan |+-+-+-+-+-
[Info @13:19:36.211]
[Info @13:19:36.211] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
[Info @13:19:36.211] Activity.ExecutePlan
[Info @13:19:36.211] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
[Info @13:19:36.227] - ContainerTask (ProgressNode) : Verify Schedule Backup Tasks
- VerifyDiskFreeSpace (VerifyNode) : Verifying that the backup path has free space
- VerifySystemIsNotBeingServiced (VerifyNode) : Verifying system is not currently being serviced
[Info @13:19:36.227]
[Info @13:19:36.227] +-+-+-+-+-| Execute |+-+-+-+-+-
[Info @13:19:36.227]
[Info @13:19:36.227] +-+-+-+-+-| Review Settings |+-+-+-+-+-
[Info @13:19:36.227]
Summary Sections
[Info @13:19:36.227]
[Info @13:19:36.227] +-+-+-+-+-| Environment |+-+-+-+-+-
[Info @13:19:36.227] Environment: BaseEnvironment
Setup:
InstallPath: C:\Program Files\Microsoft Team Foundation Server 11.0\
IsTfsExpress: False
ToolsPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Tools
ApplicationTierPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Application Tier
BuildTierPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Tools
ProxyPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Version Control Proxy
SetupUser: BNB_SYS-PC\BNB_SYS
WebServicePath: C:\Program Files\Microsoft Team Foundation Server 11.0\Application Tier\Web Services
LicenseEdition: PID_RANGE_MSDN
SystemTfsTemp: C:\Windows\Temp\TFSTemp
SharePointInstallTemp: C:\Windows\Temp\TFSTemp\WSSInstall
InstalledLanguages: System.Collections.Generic.List`1[System.Int32]
InstalledLanguagesString: 1033;
OS:
MachineName: BNB_SYS-PC
HostName: BNB_SYS-PC
IsClientOS: True
IsServerOS: False
IsDomainController: False
IsMachineInWorkgroup: True
IsMachineInDomain: False
IsHomeEdition: False
IsUnsupportedEdition: False
Version: Windows7
MajorVersion: 6
MinorVersion: 1
ProcessorCount: 4
ServicePackMajor: 1
ServicePackMinor: 0
IsOSPostTfsRelease: False
VisibleMemoryMB: 3494
AdjustedMemoryGB: 3
Iis:
IsInstalled: True
PreviouslyFailedConfig: False
RequiredIisFeaturesInstalled: True
OS:
MachineName: BNB_SYS-PC
HostName: BNB_SYS-PC
IsClientOS: True
IsServerOS: False
IsDomainController: False
IsMachineInWorkgroup: True
IsMachineInDomain: False
IsHomeEdition: False
IsUnsupportedEdition: False
Version: Windows7
MajorVersion: 6
MinorVersion: 1
ProcessorCount: 4
ServicePackMajor: 1
ServicePackMinor: 0
IsOSPostTfsRelease: False
VisibleMemoryMB: 3494
AdjustedMemoryGB: 3
Sql:
SqlInstance 0:
Name: MSSQLSERVER
FullName: BNB_SYS-PC
Edition: Developer Edition
Version: 10.50.1600.1
IsWow64: False
LCID: 1033
IsExpressEdition: False
IsFullEdition: True
IsSupported: True
IsSharePointSupported: True
IsUpgradable: False
WindowsServiceName: MSSQLSERVER
SqlInstance 1:
Name: SQLEXPRESS
FullName: BNB_SYS-PC\SqlExpress
Edition: Express Edition
Version: 11.0.2100.60
IsWow64: False
LCID: 1033
IsExpressEdition: True
IsFullEdition: False
IsSupported: True
IsSharePointSupported: False
IsUpgradable: False
WindowsServiceName: MSSQL$SQLEXPRESS
SqlInstance 2:
Name: SQLSERVER
FullName: BNB_SYS-PC\sqlserver
Edition: Standard Edition
Version: 10.50.1600.1
IsWow64: False
LCID: 1033
IsExpressEdition: False
IsFullEdition: True
IsSupported: True
IsSharePointSupported: True
IsUpgradable: False
WindowsServiceName: MSSQL$SQLSERVER
PowerTools:
IsBackupToolConfigured: False
[Info @13:19:36.227]
[Info @13:19:36.227] +-+-+-+-+-| Configuration Plan |+-+-+-+-+-
[Info @13:19:36.227] - ContainerTask (ProgressNode) : Verify Schedule Backup Tasks
- VerifyDiskFreeSpace (VerifyNode) : Verifying that the backup path has free space
- VerifySystemIsNotBeingServiced (VerifyNode) : Verifying system is not currently being serviced
[Info @13:19:36.227]
[Info @13:19:36.227] +-+-+-+-+-| Running Verify Schedule Backup Tasks: Verify Schedule Backup Tasks |+-+-+-+-+-
[Info @13:19:36.227]
[Info @13:19:36.227] +-+-+-+-+-| Verify Schedule Backup Tasks |+-+-+-+-+-
[Info @13:19:36.227] Starting Node: CONTAINER
[Info @13:19:36.227] NodePath : Progress
[Info @13:19:36.227] Node returned: Ignore
[Info @13:19:36.227] Completed Verify Schedule Backup Tasks: Ignore
[Info @13:19:36.227] -----------------------------------------------------
[Info @13:19:36.227]
[Info @13:19:36.227] +-+-+-+-+-| Running VerifyDiskFreeSpace: Verifying that the backup path has free space |+-+-+-+-+-
[Info @13:19:36.227]
[Info @13:19:36.227] +-+-+-+-+-| Verifying that the backup path has free space |+-+-+-+-+-
[Info @13:19:36.227] Starting Node: DISKFREESPACE
[Info @13:19:36.227] NodePath : Progress/DISKFREESPACE
[Info @13:19:36.227] Verifying disk free space on \\BNB_SYS-PC\TFSBackup
[Info @13:19:36.227] Node returned: Success
[Info @13:19:36.227] Completed VerifyDiskFreeSpace: Success
[Info @13:19:36.227] -----------------------------------------------------
[Info @13:19:36.227]
[Info @13:19:36.227] +-+-+-+-+-| Running VerifyConfigIsNotBeingServiced: Verifying system is not currently being serviced |+-+-+-+-+-
[Info @13:19:36.227]
[Info @13:19:36.227] +-+-+-+-+-| Verifying system is not currently being serviced |+-+-+-+-+-
[Info @13:19:36.227] Starting Node: VerifySystemIsNotBeingServiced
[Info @13:19:36.227] NodePath : Progress/VerifySystemIsNotBeingServiced
[Info @13:19:36.227] Verifying system is not currently being serviced
[Info @13:19:36.227] Checking servicing stamp on Configuration database
[Info @13:19:36.381] Node returned: Success
[Info @13:19:36.381] Completed VerifyConfigIsNotBeingServiced: Success
[Info @13:19:36.381] -----------------------------------------------------
[Info @13:19:36.381] Execution results:
[Info @13:19:36.381] Overall result: Success
[Info @13:19:36.381] Nodes completed: 2
[Info @13:19:36.381] Nodes succeeded: 2
[Info @13:19:36.381] Nodes skipped: 0
[Info @13:19:36.381] Nodes with errors: 0
[Info @13:19:36.381] Nodes with warnings: 0
[Info @13:19:36.381] Number of error messages: 0
[Info @13:19:36.381] Number of warning messages: 0
[Info @13:19:36.381] Number of info messages: 0
[Info @13:19:36.385]
[Info @13:19:36.385] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
[Info @13:19:36.385] Activity.ExecutePlan
[Info @13:19:36.385] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
[Info @13:19:36.385] - ContainerTask (ProgressNode) : Full Backup Plan
- GrantSqlPermissionToBackups (ConfigureNode, 1413) : Granting SQL permission to backup path
- PrepareDatabases (ConfigureNode, 1402) : Preparing databases for taking synchronized backups
- TakeFullBackup (ConfigureNode, 1411) : Taking full backups
[Info @13:19:36.385]
[Info @13:19:36.385] +-+-+-+-+-| Execute |+-+-+-+-+-
[Info @13:19:36.385]
[Info @13:19:36.385] +-+-+-+-+-| Review Settings |+-+-+-+-+-
[Info @13:19:36.385]
Summary Sections
[Info @13:19:36.385]
[Info @13:19:36.385] +-+-+-+-+-| Environment |+-+-+-+-+-
[Info @13:19:36.386] Environment: BaseEnvironment
Setup:
InstallPath: C:\Program Files\Microsoft Team Foundation Server 11.0\
IsTfsExpress: False
ToolsPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Tools
ApplicationTierPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Application Tier
BuildTierPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Tools
ProxyPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Version Control Proxy
SetupUser: BNB_SYS-PC\BNB_SYS
WebServicePath: C:\Program Files\Microsoft Team Foundation Server 11.0\Application Tier\Web Services
LicenseEdition: PID_RANGE_MSDN
SystemTfsTemp: C:\Windows\Temp\TFSTemp
SharePointInstallTemp: C:\Windows\Temp\TFSTemp\WSSInstall
InstalledLanguages: System.Collections.Generic.List`1[System.Int32]
InstalledLanguagesString: 1033;
OS:
MachineName: BNB_SYS-PC
HostName: BNB_SYS-PC
IsClientOS: True
IsServerOS: False
IsDomainController: False
IsMachineInWorkgroup: True
IsMachineInDomain: False
IsHomeEdition: False
IsUnsupportedEdition: False
Version: Windows7
MajorVersion: 6
MinorVersion: 1
ProcessorCount: 4
ServicePackMajor: 1
ServicePackMinor: 0
IsOSPostTfsRelease: False
VisibleMemoryMB: 3494
AdjustedMemoryGB: 3
Iis:
IsInstalled: True
PreviouslyFailedConfig: False
RequiredIisFeaturesInstalled: True
OS:
MachineName: BNB_SYS-PC
HostName: BNB_SYS-PC
IsClientOS: True
IsServerOS: False
IsDomainController: False
IsMachineInWorkgroup: True
IsMachineInDomain: False
IsHomeEdition: False
IsUnsupportedEdition: False
Version: Windows7
MajorVersion: 6
MinorVersion: 1
ProcessorCount: 4
ServicePackMajor: 1
ServicePackMinor: 0
IsOSPostTfsRelease: False
VisibleMemoryMB: 3494
AdjustedMemoryGB: 3
Sql:
SqlInstance 0:
Name: MSSQLSERVER
FullName: BNB_SYS-PC
Edition: Developer Edition
Version: 10.50.1600.1
IsWow64: False
LCID: 1033
IsExpressEdition: False
IsFullEdition: True
IsSupported: True
IsSharePointSupported: True
IsUpgradable: False
WindowsServiceName: MSSQLSERVER
SqlInstance 1:
Name: SQLEXPRESS
FullName: BNB_SYS-PC\SqlExpress
Edition: Express Edition
Version: 11.0.2100.60
IsWow64: False
LCID: 1033
IsExpressEdition: True
IsFullEdition: False
IsSupported: True
IsSharePointSupported: False
IsUpgradable: False
WindowsServiceName: MSSQL$SQLEXPRESS
SqlInstance 2:
Name: SQLSERVER
FullName: BNB_SYS-PC\sqlserver
Edition: Standard Edition
Version: 10.50.1600.1
IsWow64: False
LCID: 1033
IsExpressEdition: False
IsFullEdition: True
IsSupported: True
IsSharePointSupported: True
IsUpgradable: False
WindowsServiceName: MSSQL$SQLSERVER
PowerTools:
IsBackupToolConfigured: False
[Info @13:19:36.386]
[Info @13:19:36.386] +-+-+-+-+-| Configuration Plan |+-+-+-+-+-
[Info @13:19:36.386] - ContainerTask (ProgressNode) : Full Backup Plan
- GrantSqlPermissionToBackups (ConfigureNode, 1413) : Granting SQL permission to backup path
- PrepareDatabases (ConfigureNode, 1402) : Preparing databases for taking synchronized backups
- TakeFullBackup (ConfigureNode, 1411) : Taking full backups
[Info @13:19:36.386]
[Info @13:19:36.386] +-+-+-+-+-| Running Full Backup Plan: Full Backup Plan |+-+-+-+-+-
[Info @13:19:36.386]
[Info @13:19:36.386] +-+-+-+-+-| Full Backup Plan |+-+-+-+-+-
[Info @13:19:36.386] Starting Node: CONTAINER
[Info @13:19:36.386] NodePath : Progress
[Info @13:19:36.386] Node returned: Ignore
[Info @13:19:36.386] Completed Full Backup Plan: Ignore
[Info @13:19:36.386] -----------------------------------------------------
[Info @13:19:36.386]
[Info @13:19:36.386] +-+-+-+-+-| Running GrantSqlPermissionToBackups: Granting SQL permission to backup path |+-+-+-+-+-
[Info @13:19:36.386]
[Info @13:19:36.386] +-+-+-+-+-| Granting SQL permission to backup path |+-+-+-+-+-
[Info @13:19:36.386] Starting Node: SQLBACKUPPERMISSION
[Info @13:19:36.386] NodePath : Progress/SQLBACKUPPERMISSION
[Info @13:19:36.386] Grant SQL Server permission to backup files
[Info @13:19:36.387] Reading backup set information
[Info @13:19:36.388] Granting SQL Server permission
[Info @13:19:36.400] Granting account 'NT AUTHORITY\NETWORKSERVICE' permissions to path ''
[Warning@13:19:36.400] TF400976: SQL Server service account NT AUTHORITY\NETWORKSERVICE does not have the required permissions to create backups on the backup path
[Info @13:19:36.400] Node returned: Warning
[Warning@13:19:36.400] TF400976: SQL Server service account NT AUTHORITY\NETWORKSERVICE does not have the required permissions to create backups on the backup path
[Info @13:19:36.400] Completed GrantSqlPermissionToBackups: Warning
[Info @13:19:36.400] -----------------------------------------------------
[Info @13:19:36.400]
[Info @13:19:36.400] +-+-+-+-+-| Running PrepareDatabases: Preparing databases for taking synchronized backups |+-+-+-+-+-
[Info @13:19:36.400]
[Info @13:19:36.400] +-+-+-+-+-| Preparing databases for taking synchronized backups |+-+-+-+-+-
[Info @13:19:36.400] Starting Node: PrepareDatabases
[Info @13:19:36.400] NodePath : Progress/PrepareDatabases
[Info @13:19:36.460] Preparing databases for synchronized backups
[Info @13:19:36.460] Setting backup recovery model to Full
[Info @13:19:36.473] Creating marked transaction stored procedure
[Info @13:19:36.624] Done.
[Info @13:19:36.624] Node returned: Success
[Info @13:19:36.625] Completed PrepareDatabases: Success
[Info @13:19:36.625] -----------------------------------------------------
[Info @13:19:36.625]
[Info @13:19:36.625] +-+-+-+-+-| Running TakeFullBackup: Taking full backups |+-+-+-+-+-
[Info @13:19:36.625]
[Info @13:19:36.625] +-+-+-+-+-| Taking full backups |+-+-+-+-+-
[Info @13:19:36.625] Starting Node: TakeFullBackup
[Info @13:19:36.625] NodePath : Progress/TakeFullBackup
[Info @13:19:36.625] Taking full backups
[Info @13:19:36.625] Queue backup job
[Info @13:19:36.710] Queued job 94d6120f-b517-4832-a794-b5d0031855cb
[Info @13:19:36.710] Waiting for backup job to start
[Info @13:20:21.749] Waiting for backup job to finish
[Info @13:20:26.753] TF400983: Full Backup Job Failed
[Error @13:20:26.754] [18-02-2017 13:19:37] [Info] Full database backup job
[18-02-2017 13:19:37] [Info] Getting backup lock
[18-02-2017 13:19:37] [Info] Scanning configuration for new DBs
[18-02-2017 13:19:37] [Info] BackupSettings changed ? False
[18-02-2017 13:19:37] [Info] starting full backups
[18-02-2017 13:19:37] [Info] Taking Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244630730380F.bak
[18-02-2017 13:19:37] [Info] BACKUP DATABASE [Tfs_Configuration] TO DISK = N'\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244630730380F.bak' WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:19:41] [Info] Backup Complete for database Tfs_Configuration
[18-02-2017 13:19:41] [Info] Finished Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244630730380F.bak
[18-02-2017 13:19:41] [Info] Taking Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_DefaultCollection filename:\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244630730380F.bak
[18-02-2017 13:19:41] [Info] BACKUP DATABASE [Tfs_DefaultCollection] TO DISK = N'\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244630730380F.bak' WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:20:02] [Info] Backup Complete for database Tfs_DefaultCollection
[18-02-2017 13:20:02] [Info] Finished Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_DefaultCollection filename:\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244630730380F.bak
[18-02-2017 13:20:02] [Info] Finished Full backup set 9859602244630730380
[18-02-2017 13:20:02] [Info] Marking TFS databases
[18-02-2017 13:20:02] [Info] Executing on Tfs_DefaultCollection: BEGIN
DECLARE @text AS varchar(8000)
SELECT @text='exec prc_TfsSetTransactionLogMark TfsMarkTfpt'
EXECUTE (@text)
END
[18-02-2017 13:20:02] [Info] Executing on Tfs_Configuration: BEGIN
DECLARE @text AS varchar(8000)
SELECT @text='exec prc_TfsSetTransactionLogMark TfsMarkTfpt'
EXECUTE (@text)
END
[18-02-2017 13:20:02] [Info] Starting transactional backups
[18-02-2017 13:20:02] [Info] Database Tfs_DefaultCollection parent set is 9859602244630730380
[18-02-2017 13:20:02] [Info] Starting Transactional backup server:BNB_SYS-PC\SqlExpress database:Tfs_DefaultCollection filename:\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244883074813L.trn
[18-02-2017 13:20:02] [Info] BACKUP LOG [Tfs_DefaultCollection] TO DISK = N'\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244883074813L.trn' WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:20:20] [Error]
Exception Message: BACKUP detected corruption in the database log. Check the errorlog for more information.
BACKUP LOG is terminating abnormally. (type SqlException)
SQL Exception Class: 16
SQL Exception Number: 3049
SQL Exception Procedure:
SQL Exception Line Number: 1
SQL Exception Server: BNB_SYS-PC\SqlExpress
SQL Exception State: 1
SQL Error(s):
SQL Error[1]: System.Data.SqlClient.SqlError: BACKUP LOG is terminating abnormally.
Class: 16
Number: 3013
Server: BNB_SYS-PC\SqlExpress
Source: .Net SqlClient Data Provider
State: 1
Procedure:
Line Number: 1
Exception Data Dictionary:
HelpLink.ProdName = Microsoft SQL Server
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = 3049
HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476
Exception Stack Trace: at Microsoft.TeamFoundation.Admin.SqlDatabaseBackupRestoreComponent.Execute(String sqlStatement)
at Microsoft.TeamFoundation.Admin.SqlDatabaseBackup.Backup(String connectionString)
at Microsoft.TeamFoundation.Admin.Jobs.DatabaseBackupJob.TakeTransactionalBackupOfSingleDatabase(TeamFoundationRequestContext requestContext, String dataSource, String databaseName, String logFileName, ITFLogger logger)
at Microsoft.TeamFoundation.Admin.Jobs.DatabaseBackupJob.TakeTransactionalBackups(TeamFoundationRequestContext requestContext, BackupSettings settings, ITFLogger logger)
[18-02-2017 13:20:20] [Info] Database Tfs_Configuration parent set is 9859602244630730380
[18-02-2017 13:20:20] [Info] Starting Transactional backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244883074813L.trn
[18-02-2017 13:20:20] [Info] BACKUP LOG [Tfs_Configuration] TO DISK = N'\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244883074813L.trn' WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:20:21] [Info] Backup Complete for database Tfs_Configuration
[18-02-2017 13:20:21] [Info] Completed Transactional backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244883074813L.trn
[18-02-2017 13:20:21] [Info] Finished Transactional backup set 9859602244883074813
[18-02-2017 13:20:21] [Info] Full Backups Failed
[Info @13:20:26.754] Node returned: Error
[Error @13:20:26.756] [18-02-2017 13:19:37] [Info] Full database backup job
[18-02-2017 13:19:37] [Info] Getting backup lock
[18-02-2017 13:19:37] [Info] Scanning configuration for new DBs
[18-02-2017 13:19:37] [Info] BackupSettings changed ? False
[18-02-2017 13:19:37] [Info] starting full backups
[18-02-2017 13:19:37] [Info] Taking Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244630730380F.bak
[18-02-2017 13:19:37] [Info] BACKUP DATABASE [Tfs_Configuration] TO DISK = N'\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244630730380F.bak' WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:19:41] [Info] Backup Complete for database Tfs_Configuration
[18-02-2017 13:19:41] [Info] Finished Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244630730380F.bak
[18-02-2017 13:19:41] [Info] Taking Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_DefaultCollection filename:\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244630730380F.bak
[18-02-2017 13:19:41] [Info] BACKUP DATABASE [Tfs_DefaultCollection] TO DISK = N'\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244630730380F.bak' WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:20:02] [Info] Backup Complete for database Tfs_DefaultCollection
[18-02-2017 13:20:02] [Info] Finished Full Backup server:BNB_SYS-PC\SqlExpress database:Tfs_DefaultCollection filename:\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244630730380F.bak
[18-02-2017 13:20:02] [Info] Finished Full backup set 9859602244630730380
[18-02-2017 13:20:02] [Info] Marking TFS databases
[18-02-2017 13:20:02] [Info] Executing on Tfs_DefaultCollection: BEGIN
DECLARE @text AS varchar(8000)
SELECT @text='exec prc_TfsSetTransactionLogMark TfsMarkTfpt'
EXECUTE (@text)
END
[18-02-2017 13:20:02] [Info] Executing on Tfs_Configuration: BEGIN
DECLARE @text AS varchar(8000)
SELECT @text='exec prc_TfsSetTransactionLogMark TfsMarkTfpt'
EXECUTE (@text)
END
[18-02-2017 13:20:02] [Info] Starting transactional backups
[18-02-2017 13:20:02] [Info] Database Tfs_DefaultCollection parent set is 9859602244630730380
[18-02-2017 13:20:02] [Info] Starting Transactional backup server:BNB_SYS-PC\SqlExpress database:Tfs_DefaultCollection filename:\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244883074813L.trn
[18-02-2017 13:20:02] [Info] BACKUP LOG [Tfs_DefaultCollection] TO DISK = N'\\BNB_SYS-PC\TFSBackup\Tfs_DefaultCollection_9859602244883074813L.trn' WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:20:20] [Error]
Exception Message: BACKUP detected corruption in the database log. Check the errorlog for more information.
BACKUP LOG is terminating abnormally. (type SqlException)
SQL Exception Class: 16
SQL Exception Number: 3049
SQL Exception Procedure:
SQL Exception Line Number: 1
SQL Exception Server: BNB_SYS-PC\SqlExpress
SQL Exception State: 1
SQL Error(s):
SQL Error[1]: System.Data.SqlClient.SqlError: BACKUP LOG is terminating abnormally.
Class: 16
Number: 3013
Server: BNB_SYS-PC\SqlExpress
Source: .Net SqlClient Data Provider
State: 1
Procedure:
Line Number: 1
Exception Data Dictionary:
HelpLink.ProdName = Microsoft SQL Server
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = 3049
HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476
Exception Stack Trace: at Microsoft.TeamFoundation.Admin.SqlDatabaseBackupRestoreComponent.Execute(String sqlStatement)
at Microsoft.TeamFoundation.Admin.SqlDatabaseBackup.Backup(String connectionString)
at Microsoft.TeamFoundation.Admin.Jobs.DatabaseBackupJob.TakeTransactionalBackupOfSingleDatabase(TeamFoundationRequestContext requestContext, String dataSource, String databaseName, String logFileName, ITFLogger logger)
at Microsoft.TeamFoundation.Admin.Jobs.DatabaseBackupJob.TakeTransactionalBackups(TeamFoundationRequestContext requestContext, BackupSettings settings, ITFLogger logger)
[18-02-2017 13:20:20] [Info] Database Tfs_Configuration parent set is 9859602244630730380
[18-02-2017 13:20:20] [Info] Starting Transactional backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244883074813L.trn
[18-02-2017 13:20:20] [Info] BACKUP LOG [Tfs_Configuration] TO DISK = N'\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244883074813L.trn' WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[18-02-2017 13:20:21] [Info] Backup Complete for database Tfs_Configuration
[18-02-2017 13:20:21] [Info] Completed Transactional backup server:BNB_SYS-PC\SqlExpress database:Tfs_Configuration filename:\\BNB_SYS-PC\TFSBackup\Tfs_Configuration_9859602244883074813L.trn
[18-02-2017 13:20:21] [Info] Finished Transactional backup set 9859602244883074813
[18-02-2017 13:20:21] [Info] Full Backups Failed
[Info @13:20:26.757] Completed TakeFullBackup: Error
[Info @13:20:26.757] -----------------------------------------------------
[Info @13:20:26.757] Execution results:
[Info @13:20:26.757] Overall result: Failure, Issues
[Info @13:20:26.757] Nodes completed: 3
[Info @13:20:26.757] Nodes succeeded: 1
[Info @13:20:26.757] Nodes skipped: 0
[Info @13:20:26.757] Nodes with errors: 1
[Info @13:20:26.757] Nodes with warnings: 1
[Info @13:20:26.757] Number of error messages: 1
[Info @13:20:26.757] Number of warning messages: 1
[Info @13:20:26.757] Number of info messages: 0
[Error @13:20:26.759] Activity failed.
[Info @13:20:26.759] Activity failed and there is no handling of the failure such as rollback
推荐答案
Hi,
Here is a good blog post about this issue:
http://www.sqlskills.com/blogs/paul/how-can-a-log-backup-fail-but-a-full-backup-succeed/
Here is a good blog post about this issue: http://www.sqlskills.com/blogs/paul/how-can-a-log-backup-fail-but-a-full-backup-succeed/
Thanks,
这篇关于尝试在TFS中手动备份时备份失败。错误代码:TF400983完全备份作业失败的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!