51Testing软件测试论坛

标题: TFS 备份错误 [打印本页]

作者: qpzmsxy3819 时间: 2011-6-28 09:50
标题: TFS 备份错误
本帖最后由 qpzmsxy3819 于 2011-6-28 09:52 编辑

用TFS进行备份的时候出现如下问题，初步认为是SQL Server没有权限访问网络路径。求高手指导。

[attach]73795[/attach]

PS：TFS服务器机子IP为25，保存在本地机子（即IP为25）的网络路径上是可以的，但是在保存到异地路径（IP为37的机子）的时候出现错误。

以下为错误日志：
[Info @01:37:20.906]
[Info @01:37:20.906] +-+-+-+-+-| Starting Verification |+-+-+-+-+-
[Info @01:37:20.907]
[Info @01:37:20.907] +-+-+-+-+-| Review Settings |+-+-+-+-+-
[Info @01:37:20.907] Backup Plan Details
[Info @01:37:20.907]    Backup Path                            : \\192.168.1.139\MY_ABACKUP\backup
[Info @01:37:20.907]    Retention Days                         : 30
[Info @01:37:20.907]    Full Backup Extension                : bak
[Info @01:37:20.907]    Transactional Extension                : trn
[Info @01:37:20.907]    SMTP Host                            : None
[Info @01:37:20.907] External Databases
[Info @01:37:20.907]    Include Reporting Databases          : False
[Info @01:37:20.907]    Include SharePoint Databases          : True
[Info @01:37:20.907]    SharePoint Products SQL Server Instance : USER-U6E3P3T74K
[Info @01:37:20.907]    SharePoint Configuration Database Name  : SharePoint_Config
[Info @01:37:20.907] Backup Plan Schedules
[Info @01:37:20.907]    Backup Plan Schedule                   : Nightly Schedule
[Info @01:37:20.907] Account Information
[Info @01:37:20.907]    Account                               : NT Authority\LocalService

…………………………
…………………………
…………………………

[Info @01:37:30.166] Verify Test Backup Created Successfully
[Info @01:37:30.167] Starting creating backup test validation
[Error  @01:37:30.920] Microsoft.SqlServer.Management.Smo.FailedOperationException: 备份对于服务器“USER-U6E3P3T74K”失败。  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: 执行 Transact-SQL 语句或批处理时发生了异常。 ---> System.Data.SqlClient.SqlException: 无法打开备份设备 '\\192.168.1.139\MY_ABACKUP\backup\temp_20110628093730.bak'。出现操作系统错误 5(拒绝访问。)。
BACKUP DATABASE 正在异常终止。
在 Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
--- 内部异常堆栈跟踪的结尾 ---
在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
在 Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
在 Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
在 Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
--- 内部异常堆栈跟踪的结尾 ---
在 Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
在 Microsoft.TeamFoundation.PowerTools.Admin.Helpers.BackupFactory.TestBackupCreation(String path)
[Error  @01:37:30.990] !Verify Error!: Account USER-U6E3P3T74K\Administrator failed to create backups using path \\192.168.1.139\MY_ABACKUP\backup
[Info @01:37:30.991] "验证: Grant Backup Plan Permissions\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): 退出验证(状态为 Completed，结果为 Error)"
[Info @01:37:30.991] !Verify Result!: 4 Completed, 0 Skipped: 3 Success, 1 Errors, 0 Warnings
[Info @01:37:30.992] 验证: Backup Tasks Verifications(VCONTAINER): 开始验证
[Info @01:37:30.992] A generic container node that does not contribute to results
[Info @01:37:30.992] "验证: Backup Tasks Verifications(VCONTAINER): 退出验证(状态为 Ignore，结果为 Ignore)"
[Info @01:37:30.992] 验证: Backup Tasks Verifications\Root(VCONTAINER): 开始验证
[Info @01:37:30.992] A generic container node that does not contribute to results
[Info @01:37:30.992] "验证: Backup Tasks Verifications\Root(VCONTAINER): 退出验证(状态为 Ignore，结果为 Ignore)"
[Info @01:37:30.992] 验证: Backup Tasks Verifications\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): 开始验证
[Info @01:37:30.992] Verify Test Backup Created Successfully
[Info @01:37:30.992] Starting creating backup test validation
[Error  @01:37:31.812] Microsoft.SqlServer.Management.Smo.FailedOperationException: 备份对于服务器“USER-U6E3P3T74K”失败。  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: 执行 Transact-SQL 语句或批处理时发生了异常。 ---> System.Data.SqlClient.SqlException: 无法打开备份设备 '\\192.168.1.139\MY_ABACKUP\backup\temp_20110628093730.bak'。出现操作系统错误 5(拒绝访问。)。
BACKUP DATABASE 正在异常终止。
在 Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
--- 内部异常堆栈跟踪的结尾 ---
在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
在 Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
在 Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
在 Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
在 Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
--- 内部异常堆栈跟踪的结尾 ---
在 Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
在 Microsoft.TeamFoundation.PowerTools.Admin.Helpers.BackupFactory.TestBackupCreation(String path)
[Error  @01:37:31.883] !Verify Error!: Account USER-U6E3P3T74K\Administrator failed to create backups using path \\192.168.1.139\MY_ABACKUP\backup
[Info @01:37:31.883] "验证: Backup Tasks Verifications\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): 退出验证(状态为 Completed，结果为 Error)"
[Info @01:37:31.883] !Verify Result!: 1 Completed, 0 Skipped: 0 Success, 1 Errors, 0 Warnings
[Info @01:37:31.884]
[Info @01:37:31.884] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
[Info @01:37:31.884] Verify Summary
[Info @01:37:31.884] -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
[Info @01:37:31.884] 2 errors, 1 warnings, 0 skipped, 0 informational
[Info @01:37:31.884]
[Info @01:37:31.884] +-+-+-+-+-| Verify Complete. |+-+-+-+-+-

作者: qpzmsxy3819 时间: 2011-6-28 09:52
跪求高手~

作者: qpzmsxy3819 时间: 2011-6-30 16:39
求人才解答下~谢谢！！！！

欢迎光临 51Testing软件测试论坛 (http://bbs.51testing.com/)