尝试在TFS中手动备份时备份失败。错误代码:TF400983完全备份作业失败 [英] Backup Failing when tried to Manual Backup in TFS. Error code: TF400983 Full Backup Job failed

查看:152
本文介绍了尝试在TFS中手动备份时备份失败。错误代码:TF400983完全备份作业失败的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

[信息  @ 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]启动节点:V​​erifySystemIsNotBeingServiced

[信息  @ 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,

--Vladimir


这篇关于尝试在TFS中手动备份时备份失败。错误代码:TF400983完全备份作业失败的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆