API tools faq
paste
Advertisement
Guest User

TFSFailure130010122013

a guest
Dec 10th, 2013
407
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 41.92 KB | None | 0 0
raw download clone embed print report
  1. [Info @12:46:46.389] ====================================================================
  2. [Info @12:46:46.389] Team Foundation Server Administration Log
  3. [Info @12:46:46.389] Version : 11.0.61030.0
  4. [Info @12:46:46.389] DateTime : 12/10/2013 12:46:46
  5. [Info @12:46:46.389] Type : Scheduled Backups
  6. [Info @12:46:46.389] User : [Domain]\[User]
  7. [Info @12:46:46.389] Machine : WEB-DEVELOP
  8. [Info @12:46:46.389] System : Microsoft Windows NT 6.1.7601 Service Pack 1 (AMD64)
  9. [Info @12:46:46.389] ====================================================================
  10. [Info @12:46:46.391] IisInstaller=Iis75Installer
  11. [Info @12:46:46.391] IIS Feature value: SharedLibraries=1
  12. [Info @12:46:46.391] IIS Feature value: ProcessModelLibraries=1
  13. [Info @12:46:46.391] IIS Feature value: CoreWebEngine=1
  14. [Info @12:46:46.391] IIS Feature value: W3SVC=1
  15. [Info @12:46:46.391] IIS Feature value: Caching=1
  16. [Info @12:46:46.392] IIS Feature value: CachingBase=1
  17. [Info @12:46:46.392] IIS Feature value: HttpCache=1
  18. [Info @12:46:46.392] IIS Feature value: HttpProtocol=1
  19. [Info @12:46:46.392] IIS Feature value: RequestFiltering=1
  20. [Info @12:46:46.392] IIS Feature value: CompressionBinaries=1
  21. [Info @12:46:46.392] IIS Feature value: HttpLoggingBinaries=1
  22. [Info @12:46:46.392] IIS Feature value: HttpTracingBinaries=1
  23. [Info @12:46:46.392] IIS Feature value: IPSecurityBinaries=1
  24. [Info @12:46:46.392] IIS Feature value: RequestFilteringBinaries=1
  25. [Info @12:46:46.392] IIS Feature value: WindowsAuthenticationBinaries=1
  26. [Info @12:46:46.392] IIS Feature value: StaticContent=1
  27. [Info @12:46:46.392] IIS Feature value: DefaultDocument=1
  28. [Info @12:46:46.392] IIS Feature value: DirectoryBrowse=1
  29. [Info @12:46:46.392] IIS Feature value: HttpErrors=1
  30. [Info @12:46:46.392] IIS Feature value: HttpRedirect=1
  31. [Info @12:46:46.392] IIS Feature value: NetFxExtensibility=1
  32. [Info @12:46:46.392] IIS Feature value: ASPNET=1
  33. [Info @12:46:46.392] IIS Feature value: ISAPIExtensions=1
  34. [Info @12:46:46.392] IIS Feature value: ISAPIFilter=1
  35. [Info @12:46:46.392] IIS Feature value: ServerSideInclude=1
  36. [Info @12:46:46.392] IIS Feature value: HttpLogging=1
  37. [Info @12:46:46.392] IIS Feature value: LoggingLibraries=1
  38. [Info @12:46:46.392] IIS Feature value: RequestMonitor=1
  39. [Info @12:46:46.392] IIS Feature value: HttpTracing=1
  40. [Info @12:46:46.393] IIS Feature value: CustomLogging=1
  41. [Info @12:46:46.393] IIS Feature value: WindowsAuthentication=1
  42. [Info @12:46:46.393] IIS Feature value: HttpCompressionStatic=1
  43. [Info @12:46:46.393] IIS Feature value: HttpCompressionDynamic=1
  44. [Info @12:46:46.393] IIS Feature value: ManagementConsole=1
  45. [Info @12:46:46.393] IIS Feature value: ManagementScriptingTools=1
  46. [Info @12:46:46.393] IIS Feature value: AdminService=1
  47. [Info @12:46:46.393] IIS Feature value: ProcessModel=1
  48. [Info @12:46:46.393] IIS Feature value: NetFxEnvironment=1
  49. [Info @12:46:46.393] IIS Feature value: WASConfigurationAPI=1
  50. [Info @12:46:46.396] Environment: BaseEnvironment
  51. Setup:
  52. InstallPath: C:\Program Files\Microsoft Team Foundation Server 11.0\
  53. IsTfsExpress: True
  54. ToolsPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Tools
  55. ApplicationTierPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Application Tier
  56. BuildTierPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Tools
  57. ProxyPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Version Control Proxy
  58. SetupUser: [Domain]\[User]
  59. WebServicePath: C:\Program Files\Microsoft Team Foundation Server 11.0\Application Tier\Web Services
  60. LicenseEdition: PID_RANGE_RETAIL
  61. SystemTfsTemp: C:\Windows\Temp\TFSTemp
  62. SharePointInstallTemp: C:\Windows\Temp\TFSTemp\WSSInstall
  63. InstalledLanguages: System.Collections.Generic.List`1[System.Int32]
  64. InstalledLanguagesString: 1033;
  65. OS:
  66. MachineName: Web-Develop
  67. HostName: Web-Develop
  68. IsClientOS: False
  69. IsServerOS: True
  70. IsDomainController: False
  71. IsMachineInWorkgroup: False
  72. IsMachineInDomain: True
  73. IsHomeEdition: False
  74. IsUnsupportedEdition: False
  75. Version: Server2008R2
  76. MajorVersion: 6
  77. MinorVersion: 1
  78. ProcessorCount: 1
  79. ServicePackMajor: 1
  80. ServicePackMinor: 0
  81. IsOSPostTfsRelease: False
  82. VisibleMemoryMB: 4095
  83. AdjustedMemoryGB: 4
  84. Iis:
  85. IsInstalled: True
  86. PreviouslyFailedConfig: False
  87. RequiredIisFeaturesInstalled: True
  88. OS:
  89. MachineName: Web-Develop
  90. HostName: Web-Develop
  91. IsClientOS: False
  92. IsServerOS: True
  93. IsDomainController: False
  94. IsMachineInWorkgroup: False
  95. IsMachineInDomain: True
  96. IsHomeEdition: False
  97. IsUnsupportedEdition: False
  98. Version: Server2008R2
  99. MajorVersion: 6
  100. MinorVersion: 1
  101. ProcessorCount: 1
  102. ServicePackMajor: 1
  103. ServicePackMinor: 0
  104. IsOSPostTfsRelease: False
  105. VisibleMemoryMB: 4095
  106. AdjustedMemoryGB: 4
  107. Sql:
  108. SqlInstance 0:
  109. Name: SQLEXPRESS
  110. FullName: Web-Develop\SqlExpress
  111. Edition: Express Edition
  112. Version: 11.0.2100.60
  113. IsWow64: False
  114. LCID: 1033
  115. IsExpressEdition: True
  116. IsFullEdition: False
  117. IsSupported: True
  118. IsSharePointSupported: False
  119. IsUpgradable: False
  120. WindowsServiceName: MSSQL$SQLEXPRESS
  121. PowerTools:
  122. IsBackupToolConfigured: False
  123.  
  124. [Info @12:53:01.101] IisInstaller=Iis75Installer
  125. [Info @12:53:01.101] IIS Feature value: SharedLibraries=1
  126. [Info @12:53:01.101] IIS Feature value: ProcessModelLibraries=1
  127. [Info @12:53:01.101] IIS Feature value: CoreWebEngine=1
  128. [Info @12:53:01.101] IIS Feature value: W3SVC=1
  129. [Info @12:53:01.101] IIS Feature value: Caching=1
  130. [Info @12:53:01.101] IIS Feature value: CachingBase=1
  131. [Info @12:53:01.101] IIS Feature value: HttpCache=1
  132. [Info @12:53:01.101] IIS Feature value: HttpProtocol=1
  133. [Info @12:53:01.101] IIS Feature value: RequestFiltering=1
  134. [Info @12:53:01.101] IIS Feature value: CompressionBinaries=1
  135. [Info @12:53:01.102] IIS Feature value: HttpLoggingBinaries=1
  136. [Info @12:53:01.102] IIS Feature value: HttpTracingBinaries=1
  137. [Info @12:53:01.102] IIS Feature value: IPSecurityBinaries=1
  138. [Info @12:53:01.102] IIS Feature value: RequestFilteringBinaries=1
  139. [Info @12:53:01.102] IIS Feature value: WindowsAuthenticationBinaries=1
  140. [Info @12:53:01.102] IIS Feature value: StaticContent=1
  141. [Info @12:53:01.102] IIS Feature value: DefaultDocument=1
  142. [Info @12:53:01.102] IIS Feature value: DirectoryBrowse=1
  143. [Info @12:53:01.102] IIS Feature value: HttpErrors=1
  144. [Info @12:53:01.102] IIS Feature value: HttpRedirect=1
  145. [Info @12:53:01.102] IIS Feature value: NetFxExtensibility=1
  146. [Info @12:53:01.102] IIS Feature value: ASPNET=1
  147. [Info @12:53:01.102] IIS Feature value: ISAPIExtensions=1
  148. [Info @12:53:01.102] IIS Feature value: ISAPIFilter=1
  149. [Info @12:53:01.102] IIS Feature value: ServerSideInclude=1
  150. [Info @12:53:01.102] IIS Feature value: HttpLogging=1
  151. [Info @12:53:01.102] IIS Feature value: LoggingLibraries=1
  152. [Info @12:53:01.102] IIS Feature value: RequestMonitor=1
  153. [Info @12:53:01.102] IIS Feature value: HttpTracing=1
  154. [Info @12:53:01.102] IIS Feature value: CustomLogging=1
  155. [Info @12:53:01.102] IIS Feature value: WindowsAuthentication=1
  156. [Info @12:53:01.102] IIS Feature value: HttpCompressionStatic=1
  157. [Info @12:53:01.102] IIS Feature value: HttpCompressionDynamic=1
  158. [Info @12:53:01.102] IIS Feature value: ManagementConsole=1
  159. [Info @12:53:01.102] IIS Feature value: ManagementScriptingTools=1
  160. [Info @12:53:01.102] IIS Feature value: AdminService=1
  161. [Info @12:53:01.102] IIS Feature value: ProcessModel=1
  162. [Info @12:53:01.102] IIS Feature value: NetFxEnvironment=1
  163. [Info @12:53:01.102] IIS Feature value: WASConfigurationAPI=1
  164. [Info @12:53:01.103]
  165. [Info @12:53:01.103] +-+-+-+-+-| BackupPlanPlan::GenerateVerifyPlan |+-+-+-+-+-
  166. [Info @12:53:01.148]
  167. [Info @12:53:01.148] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
  168. [Info @12:53:01.148] Activity.ExecutePlan
  169. [Info @12:53:01.148] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
  170. [Info @12:53:01.149] - ContainerTask (ContainerNode) : Backup Databases
  171.  
  172. - ContainerTask (ProgressNode) : User Inputs
  173.  
  174. - VerifyRetentionDays (VerifyNode) : Verifying that the retention duration is between 1 and 999 days
  175.  
  176. - VerifyBackupFileExtension (VerifyNode) : Verifying backup file extensions are valid
  177.  
  178. - ContainerTask (ProgressNode) : Environment
  179.  
  180. - VerifyBackupPath (VerifyNode) : Verifying the backup path exists and is a network path
  181.  
  182. - VerifyWmiWorks (VerifyNode) : Verifying that WMI works on the local machine
  183.  
  184. - VerifyASLoads (VerifyNode) : Verifying whether the Analysis Services assembly can be loaded
  185.  
  186. - VerifySqlIsNotLocalAccount (VerifyNode) : Verifying SQL service account is not a local account
  187.  
  188. - VerifySystemIsNotBeingServiced (VerifyNode) : Verifying system is not currently being serviced
  189.  
  190. - ContainerTask (ProgressNode) : Schedule
  191.  
  192. - ContainerTask (ProgressNode) : Database Inspection
  193.  
  194. - VerifyNoDuplicateDatabases (VerifyNode) : Verifying no databases are duplicated
  195.  
  196. - VerifyBackupDatabasesAreReachable (VerifyNode) : Verifying connection strings are valid
  197.  
  198. - ContainerTask (ProgressNode) : Permissions
  199.  
  200. - VerifyJobAgentHasAlterCreatePermissions (VerifyNode) : Verifying TFS Job Agent has permissions to create and alter databases
  201.  
  202. - VerifyJobAgentHasBackupExecuteCreatePermissions (VerifyNode) : Verifying TFS Job Agent has permissions to backup databases, create tables, and execute stored procedures
  203.  
  204.  
  205. [Info @12:53:01.149]
  206. [Info @12:53:01.149] +-+-+-+-+-| Execute |+-+-+-+-+-
  207. [Info @12:53:01.149]
  208. [Info @12:53:01.149] +-+-+-+-+-| Review Settings |+-+-+-+-+-
  209. [Info @12:53:01.149]
  210. Summary Sections
  211.  
  212. Section: Backup Details
  213. Backup Path: \\[BackupServer]\c$\TFSBackup
  214. Retention Days: 30
  215. Full Backup Extension: bak
  216. Transactional Backup Extension: trn
  217. Email on backup failure: False
  218. Email on backup success: False
  219. Section: External Databases
  220. Include SharePoint Databases: False
  221. Include Reporting Databases: False
  222. Section: Backup Schedule
  223. Backup Schedule: Nightly Schedule
  224.  
  225. [Info @12:53:01.149]
  226. [Info @12:53:01.149] +-+-+-+-+-| Environment |+-+-+-+-+-
  227. [Info @12:53:01.149] Environment: BaseEnvironment
  228. Setup:
  229. InstallPath: C:\Program Files\Microsoft Team Foundation Server 11.0\
  230. IsTfsExpress: True
  231. ToolsPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Tools
  232. ApplicationTierPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Application Tier
  233. BuildTierPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Tools
  234. ProxyPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Version Control Proxy
  235. SetupUser: [Domain]\[User]
  236. WebServicePath: C:\Program Files\Microsoft Team Foundation Server 11.0\Application Tier\Web Services
  237. LicenseEdition: PID_RANGE_RETAIL
  238. SystemTfsTemp: C:\Windows\Temp\TFSTemp
  239. SharePointInstallTemp: C:\Windows\Temp\TFSTemp\WSSInstall
  240. InstalledLanguages: System.Collections.Generic.List`1[System.Int32]
  241. InstalledLanguagesString: 1033;
  242. OS:
  243. MachineName: Web-Develop
  244. HostName: Web-Develop
  245. IsClientOS: False
  246. IsServerOS: True
  247. IsDomainController: False
  248. IsMachineInWorkgroup: False
  249. IsMachineInDomain: True
  250. IsHomeEdition: False
  251. IsUnsupportedEdition: False
  252. Version: Server2008R2
  253. MajorVersion: 6
  254. MinorVersion: 1
  255. ProcessorCount: 1
  256. ServicePackMajor: 1
  257. ServicePackMinor: 0
  258. IsOSPostTfsRelease: False
  259. VisibleMemoryMB: 4095
  260. AdjustedMemoryGB: 4
  261. Iis:
  262. IsInstalled: True
  263. PreviouslyFailedConfig: False
  264. RequiredIisFeaturesInstalled: True
  265. OS:
  266. MachineName: Web-Develop
  267. HostName: Web-Develop
  268. IsClientOS: False
  269. IsServerOS: True
  270. IsDomainController: False
  271. IsMachineInWorkgroup: False
  272. IsMachineInDomain: True
  273. IsHomeEdition: False
  274. IsUnsupportedEdition: False
  275. Version: Server2008R2
  276. MajorVersion: 6
  277. MinorVersion: 1
  278. ProcessorCount: 1
  279. ServicePackMajor: 1
  280. ServicePackMinor: 0
  281. IsOSPostTfsRelease: False
  282. VisibleMemoryMB: 4095
  283. AdjustedMemoryGB: 4
  284. Sql:
  285. SqlInstance 0:
  286. Name: SQLEXPRESS
  287. FullName: Web-Develop\SqlExpress
  288. Edition: Express Edition
  289. Version: 11.0.2100.60
  290. IsWow64: False
  291. LCID: 1033
  292. IsExpressEdition: True
  293. IsFullEdition: False
  294. IsSupported: True
  295. IsSharePointSupported: False
  296. IsUpgradable: False
  297. WindowsServiceName: MSSQL$SQLEXPRESS
  298. PowerTools:
  299. IsBackupToolConfigured: False
  300.  
  301. [Info @12:53:01.149]
  302. [Info @12:53:01.149] +-+-+-+-+-| Configuration Plan |+-+-+-+-+-
  303. [Info @12:53:01.150] - ContainerTask (ContainerNode) : Backup Databases
  304.  
  305. - ContainerTask (ProgressNode) : User Inputs
  306.  
  307. - VerifyRetentionDays (VerifyNode) : Verifying that the retention duration is between 1 and 999 days
  308.  
  309. - VerifyBackupFileExtension (VerifyNode) : Verifying backup file extensions are valid
  310.  
  311. - ContainerTask (ProgressNode) : Environment
  312.  
  313. - VerifyBackupPath (VerifyNode) : Verifying the backup path exists and is a network path
  314.  
  315. - VerifyWmiWorks (VerifyNode) : Verifying that WMI works on the local machine
  316.  
  317. - VerifyASLoads (VerifyNode) : Verifying whether the Analysis Services assembly can be loaded
  318.  
  319. - VerifySqlIsNotLocalAccount (VerifyNode) : Verifying SQL service account is not a local account
  320.  
  321. - VerifySystemIsNotBeingServiced (VerifyNode) : Verifying system is not currently being serviced
  322.  
  323. - ContainerTask (ProgressNode) : Schedule
  324.  
  325. - ContainerTask (ProgressNode) : Database Inspection
  326.  
  327. - VerifyNoDuplicateDatabases (VerifyNode) : Verifying no databases are duplicated
  328.  
  329. - VerifyBackupDatabasesAreReachable (VerifyNode) : Verifying connection strings are valid
  330.  
  331. - ContainerTask (ProgressNode) : Permissions
  332.  
  333. - VerifyJobAgentHasAlterCreatePermissions (VerifyNode) : Verifying TFS Job Agent has permissions to create and alter databases
  334.  
  335. - VerifyJobAgentHasBackupExecuteCreatePermissions (VerifyNode) : Verifying TFS Job Agent has permissions to backup databases, create tables, and execute stored procedures
  336.  
  337.  
  338. [Info @12:53:01.150]
  339. [Info @12:53:01.150] +-+-+-+-+-| Running Backup Databases: Backup Databases |+-+-+-+-+-
  340. [Info @12:53:01.154]
  341. [Info @12:53:01.154] +-+-+-+-+-| Backup Databases |+-+-+-+-+-
  342. [Info @12:53:01.154] Starting Node: CONTAINER
  343. [Info @12:53:01.154] NodePath : Container
  344. [Info @12:53:01.155] Node returned: Ignore
  345. [Info @12:53:01.155] Completed Backup Databases: Ignore
  346. [Info @12:53:01.155] -----------------------------------------------------
  347. [Info @12:53:01.155]
  348. [Info @12:53:01.155] +-+-+-+-+-| Running User Inputs: User Inputs |+-+-+-+-+-
  349. [Info @12:53:01.156]
  350. [Info @12:53:01.156] +-+-+-+-+-| User Inputs |+-+-+-+-+-
  351. [Info @12:53:01.156] Starting Node: CONTAINER
  352. [Info @12:53:01.156] NodePath : Container/Progress
  353. [Info @12:53:01.156] Node returned: Ignore
  354. [Info @12:53:01.156] Completed User Inputs: Ignore
  355. [Info @12:53:01.156] -----------------------------------------------------
  356. [Info @12:53:01.156]
  357. [Info @12:53:01.156] +-+-+-+-+-| Running VerifyRetentionDays: Verifying that the retention duration is between 1 and 999 days |+-+-+-+-+-
  358. [Info @12:53:01.156]
  359. [Info @12:53:01.156] +-+-+-+-+-| Verifying that the retention duration is between 1 and 999 days |+-+-+-+-+-
  360. [Info @12:53:01.156] Starting Node: BACKUPRETENTION
  361. [Info @12:53:01.156] NodePath : Container/Progress/BACKUPRETENTION
  362. [Info @12:53:01.156] Node returned: Success
  363. [Info @12:53:01.157] Completed VerifyRetentionDays: Success
  364. [Info @12:53:01.157] -----------------------------------------------------
  365. [Info @12:53:01.157]
  366. [Info @12:53:01.157] +-+-+-+-+-| Running VerifyBackupFileExtensions: Verifying backup file extensions are valid |+-+-+-+-+-
  367. [Info @12:53:01.158]
  368. [Info @12:53:01.158] +-+-+-+-+-| Verifying backup file extensions are valid |+-+-+-+-+-
  369. [Info @12:53:01.158] Starting Node: BACKUPFILEEXTENSION
  370. [Info @12:53:01.158] NodePath : Container/Progress/BACKUPFILEEXTENSION
  371. [Info @12:53:01.158] Verifying backup file extensions
  372. [Info @12:53:01.158] Verifying full backup extension (.bak) is valid
  373. [Info @12:53:01.158] Verifying transactional backup extension (.trn) is valid
  374. [Info @12:53:01.158] Node returned: Success
  375. [Info @12:53:01.158] Completed VerifyBackupFileExtensions: Success
  376. [Info @12:53:01.158] -----------------------------------------------------
  377. [Info @12:53:01.160]
  378. [Info @12:53:01.160] +-+-+-+-+-| Running Environment: Environment |+-+-+-+-+-
  379. [Info @12:53:01.161]
  380. [Info @12:53:01.161] +-+-+-+-+-| Environment |+-+-+-+-+-
  381. [Info @12:53:01.161] Starting Node: CONTAINER
  382. [Info @12:53:01.161] NodePath : Container/Progress
  383. [Info @12:53:01.161] Node returned: Ignore
  384. [Info @12:53:01.161] Completed Environment: Ignore
  385. [Info @12:53:01.161] -----------------------------------------------------
  386. [Info @12:53:01.161]
  387. [Info @12:53:01.161] +-+-+-+-+-| Running VerifyBackupPath: Verifying the backup path exists and is a network path |+-+-+-+-+-
  388. [Info @12:53:01.162]
  389. [Info @12:53:01.162] +-+-+-+-+-| Verifying the backup path exists and is a network path |+-+-+-+-+-
  390. [Info @12:53:01.162] Starting Node: BACKUPPATH
  391. [Info @12:53:01.162] NodePath : Container/Progress/BACKUPPATH
  392. [Info @12:53:01.172] Node returned: Success
  393. [Info @12:53:01.172] Completed VerifyBackupPath: Success
  394. [Info @12:53:01.172] -----------------------------------------------------
  395. [Info @12:53:01.172]
  396. [Info @12:53:01.172] +-+-+-+-+-| Running VerifyWmiWorks: Verifying that WMI works on the local machine |+-+-+-+-+-
  397. [Info @12:53:01.173]
  398. [Info @12:53:01.173] +-+-+-+-+-| Verifying that WMI works on the local machine |+-+-+-+-+-
  399. [Info @12:53:01.173] Starting Node: VWMIWORKS
  400. [Info @12:53:01.173] NodePath : Container/Progress/VWMIWORKS
  401. [Info @12:53:01.173] Verifying that WMI works on the local machine.
  402. [Info @12:53:01.239] WMI working on local machine.
  403. [Info @12:53:01.239] Node returned: Success
  404. [Info @12:53:01.239] Completed VerifyWmiWorks: Success
  405. [Info @12:53:01.239] -----------------------------------------------------
  406. [Info @12:53:01.239]
  407. [Info @12:53:01.239] +-+-+-+-+-| Running VerifyASLoads: Verifying whether the Analysis Services assembly can be loaded |+-+-+-+-+-
  408. [Info @12:53:01.239]
  409. [Info @12:53:01.239] +-+-+-+-+-| Verifying whether the Analysis Services assembly can be loaded |+-+-+-+-+-
  410. [Info @12:53:01.239] Starting Node: VASLOADS
  411. [Info @12:53:01.239] NodePath : Container/Progress/VASLOADS
  412. [Info @12:53:01.239] Trying to load Microsoft.AnalysisServices in a test AppDomain.
  413. [Info @12:53:02.116] Was able to load Microsoft.AnalysisServices in a test AppDomain.
  414. [Info @12:53:02.116] Trying to load Microsoft.AnalysisServices in the main AppDomain.
  415. [Info @12:53:02.116] Was able to load Microsoft.AnalysisServices in the main AppDomain.
  416. [Info @12:53:02.124] Node returned: Success
  417. [Info @12:53:02.124] Completed VerifyASLoads: Success
  418. [Info @12:53:02.124] -----------------------------------------------------
  419. [Info @12:53:02.124]
  420. [Info @12:53:02.124] +-+-+-+-+-| Running VerifySqlServiceAccountCanBeGrantedPermission: Verifying SQL service account is not a local account |+-+-+-+-+-
  421. [Info @12:53:02.125]
  422. [Info @12:53:02.125] +-+-+-+-+-| Verifying SQL service account is not a local account |+-+-+-+-+-
  423. [Info @12:53:02.125] Starting Node: SQLISNOTLOCAL
  424. [Info @12:53:02.125] NodePath : Container/Progress/SQLISNOTLOCAL
  425. [Info @12:53:02.143] Verify that account '[Domain]\WEB-DEVELOP$' is not local service or local system.
  426. [Info @12:53:02.143] Node returned: Success
  427. [Info @12:53:02.143] Completed VerifySqlServiceAccountCanBeGrantedPermission: Success
  428. [Info @12:53:02.143] -----------------------------------------------------
  429. [Info @12:53:02.143]
  430. [Info @12:53:02.143] +-+-+-+-+-| Running VerifyConfigIsNotBeingServiced: Verifying system is not currently being serviced |+-+-+-+-+-
  431. [Info @12:53:02.144]
  432. [Info @12:53:02.144] +-+-+-+-+-| Verifying system is not currently being serviced |+-+-+-+-+-
  433. [Info @12:53:02.144] Starting Node: VerifySystemIsNotBeingServiced
  434. [Info @12:53:02.144] NodePath : Container/Progress/VerifySystemIsNotBeingServiced
  435. [Info @12:53:02.144] Verifying system is not currently being serviced
  436. [Info @12:53:02.145] Checking servicing stamp on Configuration database
  437. [Info @12:53:02.147] Node returned: Success
  438. [Info @12:53:02.147] Completed VerifyConfigIsNotBeingServiced: Success
  439. [Info @12:53:02.147] -----------------------------------------------------
  440. [Info @12:53:02.148]
  441. [Info @12:53:02.148] +-+-+-+-+-| Running Schedule: Schedule |+-+-+-+-+-
  442. [Info @12:53:02.149]
  443. [Info @12:53:02.149] +-+-+-+-+-| Schedule |+-+-+-+-+-
  444. [Info @12:53:02.149] Starting Node: CONTAINER
  445. [Info @12:53:02.149] NodePath : Container/Progress
  446. [Info @12:53:02.149] Node returned: Ignore
  447. [Info @12:53:02.149] Completed Schedule: Ignore
  448. [Info @12:53:02.149] -----------------------------------------------------
  449. [Info @12:53:02.150]
  450. [Info @12:53:02.150] +-+-+-+-+-| Running Database Inspection: Database Inspection |+-+-+-+-+-
  451. [Info @12:53:02.151]
  452. [Info @12:53:02.151] +-+-+-+-+-| Database Inspection |+-+-+-+-+-
  453. [Info @12:53:02.151] Starting Node: CONTAINER
  454. [Info @12:53:02.151] NodePath : Container/Progress
  455. [Info @12:53:02.151] Node returned: Ignore
  456. [Info @12:53:02.151] Completed Database Inspection: Ignore
  457. [Info @12:53:02.151] -----------------------------------------------------
  458. [Info @12:53:02.151]
  459. [Info @12:53:02.151] +-+-+-+-+-| Running VerifyNoDuplicateDatabases: Verifying no databases are duplicated |+-+-+-+-+-
  460. [Info @12:53:02.151]
  461. [Info @12:53:02.151] +-+-+-+-+-| Verifying no databases are duplicated |+-+-+-+-+-
  462. [Info @12:53:02.151] Starting Node: VNODUPLICATEDBS
  463. [Info @12:53:02.151] NodePath : Container/Progress/VNODUPLICATEDBS
  464. [Info @12:53:02.151] Verifying no databases are duplicated in the list
  465. [Info @12:53:02.152] Node returned: Success
  466. [Info @12:53:02.152] Completed VerifyNoDuplicateDatabases: Success
  467. [Info @12:53:02.152] -----------------------------------------------------
  468. [Info @12:53:02.152]
  469. [Info @12:53:02.152] +-+-+-+-+-| Running VerifyCollectionDatabases: Verifying connection strings are valid |+-+-+-+-+-
  470. [Info @12:53:02.152]
  471. [Info @12:53:02.152] +-+-+-+-+-| Verifying connection strings are valid |+-+-+-+-+-
  472. [Info @12:53:02.152] Starting Node: BACKUPDBSREACHABLE
  473. [Info @12:53:02.152] NodePath : Container/Progress/BACKUPDBSREACHABLE
  474. [Info @12:53:02.152] Verifying connection strings to all backup databases
  475. [Info @12:53:02.153] Looking for database Tfs_Configuration on Web-Develop\SqlExpress
  476. [Info @12:53:02.156] Checking if database Tfs_Configuration on Web-Develop\SqlExpress is online
  477. [Info @12:53:02.159] Looking for database Tfs_Test on Web-Develop\SqlExpress
  478. [Info @12:53:02.159] Checking if database Tfs_Test on Web-Develop\SqlExpress is online
  479. [Info @12:53:02.160] Looking for database Tfs_DefaultCollection on Web-Develop\SqlExpress
  480. [Info @12:53:02.160] Checking if database Tfs_DefaultCollection on Web-Develop\SqlExpress is online
  481. [Info @12:53:02.162] Looking for database Tfs_MCSU Resource Management on Web-Develop\SqlExpress
  482. [Info @12:53:02.162] Checking if database Tfs_MCSU Resource Management on Web-Develop\SqlExpress is online
  483. [Info @12:53:02.163] Node returned: Success
  484. [Info @12:53:02.163] Completed VerifyCollectionDatabases: Success
  485. [Info @12:53:02.163] -----------------------------------------------------
  486. [Info @12:53:02.165]
  487. [Info @12:53:02.165] +-+-+-+-+-| Running Permissions: Permissions |+-+-+-+-+-
  488. [Info @12:53:02.165]
  489. [Info @12:53:02.165] +-+-+-+-+-| Permissions |+-+-+-+-+-
  490. [Info @12:53:02.165] Starting Node: CONTAINER
  491. [Info @12:53:02.165] NodePath : Container/Progress
  492. [Info @12:53:02.165] Node returned: Ignore
  493. [Info @12:53:02.165] Completed Permissions: Ignore
  494. [Info @12:53:02.165] -----------------------------------------------------
  495. [Info @12:53:02.165]
  496. [Info @12:53:02.165] +-+-+-+-+-| Running VerifySqlServerPermissionsGranted: Verifying TFS Job Agent has permissions to create and alter databases |+-+-+-+-+-
  497. [Info @12:53:02.166]
  498. [Info @12:53:02.166] +-+-+-+-+-| Verifying TFS Job Agent has permissions to create and alter databases |+-+-+-+-+-
  499. [Info @12:53:02.166] Starting Node: ALTERCREATEDATABASE
  500. [Info @12:53:02.166] NodePath : Container/Progress/ALTERCREATEDATABASE
  501. [Info @12:53:02.170] Node returned: Success
  502. [Info @12:53:02.170] Completed VerifySqlServerPermissionsGranted: Success
  503. [Info @12:53:02.170] -----------------------------------------------------
  504. [Info @12:53:02.170]
  505. [Info @12:53:02.170] +-+-+-+-+-| Running VerifySqlDatabasesPermissionsGranted: Verifying TFS Job Agent has permissions to backup databases, create tables, and execute stored procedures |+-+-+-+-+-
  506. [Info @12:53:02.171]
  507. [Info @12:53:02.171] +-+-+-+-+-| Verifying TFS Job Agent has permissions to backup databases, create tables, and execute stored procedures |+-+-+-+-+-
  508. [Info @12:53:02.171] Starting Node: BACKUPEXECUTECREATE
  509. [Info @12:53:02.171] NodePath : Container/Progress/BACKUPEXECUTECREATE
  510. [Info @12:53:02.171] Granting account NT AUTHORITY\NETWORK SERVICE permissions to initiate database backups of Tfs_Configuration
  511. [Info @12:53:02.211] Granting account NT AUTHORITY\NETWORK SERVICE permissions to initiate database backups of Tfs_Test
  512. [Info @12:53:04.354] Granting account NT AUTHORITY\NETWORK SERVICE permissions to initiate database backups of Tfs_DefaultCollection
  513. [Info @12:53:08.440] Granting account NT AUTHORITY\NETWORK SERVICE permissions to initiate database backups of Tfs_MCSU Resource Management
  514. [Info @12:53:11.085] Node returned: Success
  515. [Info @12:53:11.085] Completed VerifySqlDatabasesPermissionsGranted: Success
  516. [Info @12:53:11.085] -----------------------------------------------------
  517. [Info @12:53:11.086] Execution results:
  518. [Info @12:53:11.086] Overall result: Success
  519. [Info @12:53:11.086] Nodes completed: 11
  520. [Info @12:53:11.086] Nodes succeeded: 11
  521. [Info @12:53:11.086] Nodes skipped: 2
  522. [Info @12:53:11.086] Nodes with errors: 0
  523. [Info @12:53:11.086] Nodes with warnings: 0
  524. [Info @12:53:11.086] Number of error messages: 0
  525. [Info @12:53:11.086] Number of warning messages: 0
  526. [Info @12:53:11.086] Number of info messages: 0
  527. [Info @12:55:10.118]
  528. [Info @12:55:10.118] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
  529. [Info @12:55:10.118] Activity.ExecutePlan
  530. [Info @12:55:10.118] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
  531. [Info @12:55:10.118] - ContainerTask (ContainerNode) : Create Backup Plan
  532.  
  533. - ContainerTask (ProgressNode) : Registering Notifications
  534.  
  535. - RecordBackupSettings (ConfigureNode, 1403) : Recording Backup Settings
  536.  
  537. - RegisterBackupNotifications (ConfigureNode, 1404) : Registering database backup notifications
  538.  
  539. - ContainerTask (ProgressNode) : Preparing Databases
  540.  
  541. - PrepareDatabases (ConfigureNode, 1402) : Preparing databases for taking synchronized backups
  542.  
  543. - GrantJobAgentBackupPermissions (ConfigureNode, 1401) : Granting Job Agent Backup Permissions
  544.  
  545. - GrantSqlPermissionToBackups (ConfigureNode, 1413) : Granting SQL permission to backup path
  546.  
  547. - ContainerTask (ProgressNode) : Confirming Permissions
  548.  
  549. - TakeDummyDatabaseBackup (ConfigureNode, 1410) : Verifying backing up an empty database succeeds
  550.  
  551. - ContainerTask (ProgressNode) : Scheduling Jobs
  552.  
  553. - ScheduleBackupJobs (ConfigureNode, 1409) : Scheduling Backup Jobs
  554.  
  555. - ContainerTask (ProgressNode) : Saving Settings
  556.  
  557. - SaveBackupSettings (ConfigureNode, 1407) : Saving Backup Settings
  558.  
  559. - DeletePowerToolArtifacts (ConfigureNode, 1400) : Deleting Backup Restore Power Tool artifacts
  560.  
  561.  
  562. [Info @12:55:10.118]
  563. [Info @12:55:10.118] +-+-+-+-+-| Execute |+-+-+-+-+-
  564. [Info @12:55:10.118]
  565. [Info @12:55:10.118] +-+-+-+-+-| Review Settings |+-+-+-+-+-
  566. [Info @12:55:10.118]
  567. Summary Sections
  568.  
  569. Section: Backup Details
  570. Backup Path: \\[BackupServer]\c$\TFSBackup
  571. Retention Days: 30
  572. Full Backup Extension: bak
  573. Transactional Backup Extension: trn
  574. Email on backup failure: False
  575. Email on backup success: False
  576. Section: External Databases
  577. Include SharePoint Databases: False
  578. Include Reporting Databases: False
  579. Section: Backup Schedule
  580. Backup Schedule: Nightly Schedule
  581.  
  582. [Info @12:55:10.118]
  583. [Info @12:55:10.118] +-+-+-+-+-| Environment |+-+-+-+-+-
  584. [Info @12:55:10.119] Environment: BaseEnvironment
  585. Setup:
  586. InstallPath: C:\Program Files\Microsoft Team Foundation Server 11.0\
  587. IsTfsExpress: True
  588. ToolsPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Tools
  589. ApplicationTierPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Application Tier
  590. BuildTierPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Tools
  591. ProxyPath: C:\Program Files\Microsoft Team Foundation Server 11.0\Version Control Proxy
  592. SetupUser: [Domain]\[User]
  593. WebServicePath: C:\Program Files\Microsoft Team Foundation Server 11.0\Application Tier\Web Services
  594. LicenseEdition: PID_RANGE_RETAIL
  595. SystemTfsTemp: C:\Windows\Temp\TFSTemp
  596. SharePointInstallTemp: C:\Windows\Temp\TFSTemp\WSSInstall
  597. InstalledLanguages: System.Collections.Generic.List`1[System.Int32]
  598. InstalledLanguagesString: 1033;
  599. OS:
  600. MachineName: Web-Develop
  601. HostName: Web-Develop
  602. IsClientOS: False
  603. IsServerOS: True
  604. IsDomainController: False
  605. IsMachineInWorkgroup: False
  606. IsMachineInDomain: True
  607. IsHomeEdition: False
  608. IsUnsupportedEdition: False
  609. Version: Server2008R2
  610. MajorVersion: 6
  611. MinorVersion: 1
  612. ProcessorCount: 1
  613. ServicePackMajor: 1
  614. ServicePackMinor: 0
  615. IsOSPostTfsRelease: False
  616. VisibleMemoryMB: 4095
  617. AdjustedMemoryGB: 4
  618. Iis:
  619. IsInstalled: True
  620. PreviouslyFailedConfig: False
  621. RequiredIisFeaturesInstalled: True
  622. OS:
  623. MachineName: Web-Develop
  624. HostName: Web-Develop
  625. IsClientOS: False
  626. IsServerOS: True
  627. IsDomainController: False
  628. IsMachineInWorkgroup: False
  629. IsMachineInDomain: True
  630. IsHomeEdition: False
  631. IsUnsupportedEdition: False
  632. Version: Server2008R2
  633. MajorVersion: 6
  634. MinorVersion: 1
  635. ProcessorCount: 1
  636. ServicePackMajor: 1
  637. ServicePackMinor: 0
  638. IsOSPostTfsRelease: False
  639. VisibleMemoryMB: 4095
  640. AdjustedMemoryGB: 4
  641. Sql:
  642. SqlInstance 0:
  643. Name: SQLEXPRESS
  644. FullName: Web-Develop\SqlExpress
  645. Edition: Express Edition
  646. Version: 11.0.2100.60
  647. IsWow64: False
  648. LCID: 1033
  649. IsExpressEdition: True
  650. IsFullEdition: False
  651. IsSupported: True
  652. IsSharePointSupported: False
  653. IsUpgradable: False
  654. WindowsServiceName: MSSQL$SQLEXPRESS
  655. PowerTools:
  656. IsBackupToolConfigured: False
  657.  
  658. [Info @12:55:10.119]
  659. [Info @12:55:10.119] +-+-+-+-+-| Configuration Plan |+-+-+-+-+-
  660. [Info @12:55:10.119] - ContainerTask (ContainerNode) : Create Backup Plan
  661.  
  662. - ContainerTask (ProgressNode) : Registering Notifications
  663.  
  664. - RecordBackupSettings (ConfigureNode, 1403) : Recording Backup Settings
  665.  
  666. - RegisterBackupNotifications (ConfigureNode, 1404) : Registering database backup notifications
  667.  
  668. - ContainerTask (ProgressNode) : Preparing Databases
  669.  
  670. - PrepareDatabases (ConfigureNode, 1402) : Preparing databases for taking synchronized backups
  671.  
  672. - GrantJobAgentBackupPermissions (ConfigureNode, 1401) : Granting Job Agent Backup Permissions
  673.  
  674. - GrantSqlPermissionToBackups (ConfigureNode, 1413) : Granting SQL permission to backup path
  675.  
  676. - ContainerTask (ProgressNode) : Confirming Permissions
  677.  
  678. - TakeDummyDatabaseBackup (ConfigureNode, 1410) : Verifying backing up an empty database succeeds
  679.  
  680. - ContainerTask (ProgressNode) : Scheduling Jobs
  681.  
  682. - ScheduleBackupJobs (ConfigureNode, 1409) : Scheduling Backup Jobs
  683.  
  684. - ContainerTask (ProgressNode) : Saving Settings
  685.  
  686. - SaveBackupSettings (ConfigureNode, 1407) : Saving Backup Settings
  687.  
  688. - DeletePowerToolArtifacts (ConfigureNode, 1400) : Deleting Backup Restore Power Tool artifacts
  689.  
  690.  
  691. [Info @12:55:10.119]
  692. [Info @12:55:10.119] +-+-+-+-+-| Running Create Backup Plan: Create Backup Plan |+-+-+-+-+-
  693. [Info @12:55:10.120]
  694. [Info @12:55:10.120] +-+-+-+-+-| Create Backup Plan |+-+-+-+-+-
  695. [Info @12:55:10.120] Starting Node: CONTAINER
  696. [Info @12:55:10.120] NodePath : Container
  697. [Info @12:55:10.120] Node returned: Ignore
  698. [Info @12:55:10.120] Completed Create Backup Plan: Ignore
  699. [Info @12:55:10.120] -----------------------------------------------------
  700. [Info @12:55:10.121]
  701. [Info @12:55:10.121] +-+-+-+-+-| Running Registering Notifications: Registering Notifications |+-+-+-+-+-
  702. [Info @12:55:10.121]
  703. [Info @12:55:10.121] +-+-+-+-+-| Registering Notifications |+-+-+-+-+-
  704. [Info @12:55:10.121] Starting Node: CONTAINER
  705. [Info @12:55:10.121] NodePath : Container/Progress
  706. [Info @12:55:10.121] Node returned: Ignore
  707. [Info @12:55:10.121] Completed Registering Notifications: Ignore
  708. [Info @12:55:10.121] -----------------------------------------------------
  709. [Info @12:55:10.121]
  710. [Info @12:55:10.121] +-+-+-+-+-| Running SetConfigurationSettings: Recording Backup Settings |+-+-+-+-+-
  711. [Info @12:55:10.122]
  712. [Info @12:55:10.122] +-+-+-+-+-| Recording Backup Settings |+-+-+-+-+-
  713. [Info @12:55:10.122] Starting Node: SetConfigurationSettings
  714. [Info @12:55:10.122] NodePath : Container/Progress/SetConfigurationSettings
  715. [Info @12:55:10.167] Node returned: Success
  716. [Info @12:55:10.167] Completed SetConfigurationSettings: Success
  717. [Info @12:55:10.167] -----------------------------------------------------
  718. [Info @12:55:10.167]
  719. [Info @12:55:10.167] +-+-+-+-+-| Running RegisterBackupNotifications: Registering database backup notifications |+-+-+-+-+-
  720. [Info @12:55:10.167]
  721. [Info @12:55:10.167] +-+-+-+-+-| Registering database backup notifications |+-+-+-+-+-
  722. [Info @12:55:10.167] Starting Node: RegisterBackupNotifications
  723. [Info @12:55:10.167] NodePath : Container/Progress/RegisterBackupNotifications
  724. [Info @12:55:10.174] Node returned: Success
  725. [Info @12:55:10.174] Completed RegisterBackupNotifications: Success
  726. [Info @12:55:10.174] -----------------------------------------------------
  727. [Info @12:55:10.175]
  728. [Info @12:55:10.175] +-+-+-+-+-| Running Preparing Databases: Preparing Databases |+-+-+-+-+-
  729. [Info @12:55:10.176]
  730. [Info @12:55:10.176] +-+-+-+-+-| Preparing Databases |+-+-+-+-+-
  731. [Info @12:55:10.176] Starting Node: CONTAINER
  732. [Info @12:55:10.176] NodePath : Container/Progress
  733. [Info @12:55:10.176] Node returned: Ignore
  734. [Info @12:55:10.176] Completed Preparing Databases: Ignore
  735. [Info @12:55:10.176] -----------------------------------------------------
  736. [Info @12:55:10.176]
  737. [Info @12:55:10.176] +-+-+-+-+-| Running PrepareDatabases: Preparing databases for taking synchronized backups |+-+-+-+-+-
  738. [Info @12:55:10.176]
  739. [Info @12:55:10.176] +-+-+-+-+-| Preparing databases for taking synchronized backups |+-+-+-+-+-
  740. [Info @12:55:10.176] Starting Node: PrepareDatabases
  741. [Info @12:55:10.176] NodePath : Container/Progress/PrepareDatabases
  742. [Info @12:55:10.178] Preparing databases for synchronized backups
  743. [Info @12:55:10.178] Setting backup recovery model to Full
  744. [Info @12:55:10.183] Creating marked transaction stored procedure
  745. [Info @12:55:11.416] Done.
  746. [Info @12:55:11.416] Node returned: Success
  747. [Info @12:55:11.416] Completed PrepareDatabases: Success
  748. [Info @12:55:11.416] -----------------------------------------------------
  749. [Info @12:55:11.416]
  750. [Info @12:55:11.416] +-+-+-+-+-| Running GiveJobAgentBackupPermissions: Granting Job Agent Backup Permissions |+-+-+-+-+-
  751. [Info @12:55:11.417]
  752. [Info @12:55:11.417] +-+-+-+-+-| Granting Job Agent Backup Permissions |+-+-+-+-+-
  753. [Info @12:55:11.417] Starting Node: JABACKUPPERMISSION
  754. [Info @12:55:11.417] NodePath : Container/Progress/JABACKUPPERMISSION
  755. [Info @12:55:11.417] Grant Job Agent Backup Permissions
  756. [Info @12:55:11.418]
  757. [Info @12:55:11.418] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
  758. [Info @12:55:11.418] Granting account NT AUTHORITY\NETWORK SERVICE SQL backup permissions
  759. [Info @12:55:11.418] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
  760. [Info @12:55:11.418] Granting account NT AUTHORITY\NETWORK SERVICE permissions to alter and create databases on web-develop\sqlexpress
  761. [Info @12:55:11.423] Granting account NT AUTHORITY\NETWORK SERVICE permissions to initiate database backups of Tfs_Configuration
  762. [Info @12:55:11.428] Granting account NT AUTHORITY\NETWORK SERVICE permissions to initiate database backups of Tfs_Test
  763. [Info @12:55:11.431] Granting account NT AUTHORITY\NETWORK SERVICE permissions to initiate database backups of Tfs_DefaultCollection
  764. [Info @12:55:11.436] Granting account NT AUTHORITY\NETWORK SERVICE permissions to initiate database backups of Tfs_MCSU Resource Management
  765. [Info @12:55:11.447]
  766. [Info @12:55:11.447] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
  767. [Info @12:55:11.447]
  768. [Info @12:55:11.447] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
  769. [Info @12:55:11.447]
  770. [Info @12:55:11.449]
  771. [Info @12:55:11.449] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
  772. [Info @12:55:11.449] Granting account permissions on logs folder
  773. [Info @12:55:11.449] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
  774. [Info @12:55:11.449] Granting account NT AUTHORITY\NETWORK SERVICE full control permissions to file path \\[BackupServer]\c$\TFSBackup
  775. [Info @12:55:11.449] Granting Job Agent NT AUTHORITY\NETWORK SERVICE permission to the backup path \\[BackupServer]\c$\TFSBackup
  776. [Info @12:55:11.461] Granting Job Agent [Domain]\WEB-DEVELOP$ permission to the backup path \\[BackupServer]\c$\TFSBackup
  777. [Info @12:55:11.471] Done.
  778. [Info @12:55:11.472] Node returned: Success
  779. [Info @12:55:11.472] Completed GiveJobAgentBackupPermissions: Success
  780. [Info @12:55:11.472] -----------------------------------------------------
  781. [Info @12:55:11.472]
  782. [Info @12:55:11.472] +-+-+-+-+-| Running GrantSqlPermissionToBackups: Granting SQL permission to backup path |+-+-+-+-+-
  783. [Info @12:55:11.472]
  784. [Info @12:55:11.472] +-+-+-+-+-| Granting SQL permission to backup path |+-+-+-+-+-
  785. [Info @12:55:11.472] Starting Node: SQLBACKUPPERMISSION
  786. [Info @12:55:11.472] NodePath : Container/Progress/SQLBACKUPPERMISSION
  787. [Info @12:55:11.472] Grant SQL Server permission to backup files
  788. [Info @12:55:11.473] Reading backup set information
  789. [Info @12:55:11.473] Granting SQL Server permission
  790. [Info @12:55:11.496] Granting account '[Domain]\WEB-DEVELOP$' permissions to path '\\[BackupServer]\c$\TFSBackup'
  791. [Info @12:55:11.502] Node returned: Success
  792. [Info @12:55:11.502] Completed GrantSqlPermissionToBackups: Success
  793. [Info @12:55:11.502] -----------------------------------------------------
  794. [Info @12:55:11.504]
  795. [Info @12:55:11.504] +-+-+-+-+-| Running Confirming Permissions: Confirming Permissions |+-+-+-+-+-
  796. [Info @12:55:11.504]
  797. [Info @12:55:11.504] +-+-+-+-+-| Confirming Permissions |+-+-+-+-+-
  798. [Info @12:55:11.504] Starting Node: CONTAINER
  799. [Info @12:55:11.504] NodePath : Container/Progress
  800. [Info @12:55:11.504] Node returned: Ignore
  801. [Info @12:55:11.504] Completed Confirming Permissions: Ignore
  802. [Info @12:55:11.504] -----------------------------------------------------
  803. [Info @12:55:11.505]
  804. [Info @12:55:11.505] +-+-+-+-+-| Running VerifyCanBackupDatabase: Verifying backing up an empty database succeeds |+-+-+-+-+-
  805. [Info @12:55:11.505]
  806. [Info @12:55:11.505] +-+-+-+-+-| Verifying backing up an empty database succeeds |+-+-+-+-+-
  807. [Info @12:55:11.505] Starting Node: DUMMYDATABASE
  808. [Info @12:55:11.505] NodePath : Container/Progress/DUMMYDATABASE
  809. [Info @12:55:11.506] Creating dummy database to test backup.
  810. [Info @12:55:13.001] Queue verify backup job
  811. [Info @12:55:13.019] Queued job 0a3d90a0-224b-4cf4-9cad-915e6b3790b8
  812. [Info @12:55:13.019] Starting backup job to verify necessary permissions
  813. [Info @12:55:18.020] Waiting for backup job to finish
  814. [Error @12:55:23.022] Backup job Failed: TF400797: Job extension had an unhandled error: System.Data.SqlClient.SqlException (0x80131904): Cannot open backup device '\\[BackupServer]\c$\TFSBackup\Tfs_Temp27fd8d66-11bf-4077-9839-2b1009b886e2.bak'. Operating system error 5(Access is denied.).
  815. BACKUP DATABASE is terminating abnormally.
  816. at Microsoft.TeamFoundation.Admin.SqlDatabaseBackupRestoreComponent.Execute(String sqlStatement)
  817. at Microsoft.TeamFoundation.Admin.SqlDatabaseBackup.Backup(String connectionString)
  818. at Microsoft.TeamFoundation.Admin.Jobs.DatabaseBackupJob.TakeFullBackupOfSingleDatabase(TeamFoundationRequestContext requestContext, String dataSource, String databaseName, String fullFileName, ITFLogger logger)
  819. at Microsoft.TeamFoundation.Admin.Jobs.VerifyBackupPermissionsJobExtension.Run(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime jobQueueTime, String& resultMessage)
  820. at Microsoft.TeamFoundation.Framework.Server.JobRunner.ExecuteJob()
  821. ClientConnectionId:00000000-0000-0000-0000-000000000000
  822. [Info @12:55:26.050] Node returned: Error
  823. [Error @12:55:26.050] TF401002: The SQL Server Database Engine failed to save the database backup to path \\[BackupServer]\c$\TFSBackup. Please grant SQL service account read/write access to that folder.
  824. [Info @12:55:26.050] Completed VerifyCanBackupDatabase: Error
  825. [Info @12:55:26.050] -----------------------------------------------------
  826. [Info @12:55:26.052] Execution results:
  827. [Info @12:55:26.052] Overall result: Failure
  828. [Info @12:55:26.052] Nodes completed: 6
  829. [Info @12:55:26.052] Nodes succeeded: 5
  830. [Info @12:55:26.052] Nodes skipped: 0
  831. [Info @12:55:26.052] Nodes with errors: 1
  832. [Info @12:55:26.052] Nodes with warnings: 0
  833. [Info @12:55:26.052] Number of error messages: 1
  834. [Info @12:55:26.052] Number of warning messages: 0
  835. [Info @12:55:26.052] Number of info messages: 0
  836. [Error @12:55:26.053] Activity failed.
  837. [Info @12:55:26.053] Activity failed and there is no handling of the failure such as rollback
  838. [Info @12:55:26.053]
  839. [Info @12:55:26.053] +-+-+-+-+-| ResultsSqmData |+-+-+-+-+-
  840. [Warning@12:55:26.053] Feature type missing
  841. [Info @12:55:26.053] Feature: None (0)
  842. [Info @12:55:26.053] Feature: None; previousFailure: False
  843. [Info @12:55:26.053] Error count: 1
  844. [Info @12:55:26.053] Warning count: 0
  845. [Info @12:55:26.053] Overall Result: Failure (3)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!