TFS 2015 - TF401002:SQL Server 数据库引擎未能将数据库备份保存到路径 [英] TFS 2015 - TF401002: The SQL Server Database Engine failed to save the database backup to path

问题描述

尝试为 TFS 2015 创建计划备份时，我收到以下消息:TF401002:SQL Server 数据库引擎未能将数据库备份保存到路径 \{share}\d$\TFSBackups.请授予 SQL 服务帐户对该文件夹的读/写访问权限."

When attempting to create scheduled backups for TFS 2015, I received the following message: "TF401002: The SQL Server Database Engine failed to save the database backup to path \{share}\d$\TFSBackups. Please grant SQL service account read/write access to that folder."

我似乎找不到适合我的解决方案.TFSBackups"文件夹与网络服务和 MSSQLSERVER 的完全权限共享.

I can't seem to find a solution that will work for me. The 'TFSBackups' folder is shared with full permissions for the NETWORK SERVICE and MSSQLSERVER.

我还没有做什么?

推荐答案

将 Panagiotis Kanavos 的评论放在答案中.

Put the comment from Panagiotis Kanavos in the answer.

错误信息非常清晰，与 TFS 无关.该帐户无权写入该文件夹.

The error message is crystal clear and has nothing to do with TFS. That account doesn't have permission to write to that folder.

该路径不是有效共享的路径，它使用管理端点 d$ 直接访问物理驱动器.只有管​​理员允许使用管理端点.

The path is NOT a path to a valid share, it uses the administrative endpoint d$ to directly access a physical drive. Only administrators are allowed to use administrative endpoints.

只需共享 TFSBackups，设置适当的权限并使用共享的路径，例如 \\MyStorageMachine\TFSBackups

Just share TFSBackups, set the proper permissions and use the share's path, eg \\MyStorageMachine\TFSBackups

这篇关于TFS 2015 - TF401002:SQL Server 数据库引擎未能将数据库备份保存到路径的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！