TFS 2012 - Scheduled Backups

Question

I am trying to configure Nightly Backups for my TFS 2012.4 development window, which goes to another server, but it does not work.

The server has SQL Express and TFS Express, trying to send backups on a network path to another resource.

When passing through the wizard, he will successfully conduct all readiness checks, including permissions. It will fail when it tries to run the backup job for the first time in the Permission Confirmation section.

Error:

TF401002: SQL Server Database Engine was unable to save the backup database to the path \ [share] \ c $ \ TFSBackup. Grant the SQL service access to the account record / account in this folder.

I tried to add “All” with full control to the folder on the backup server, but it still does not work with the same error.

Added full magazine at http://pastebin.com/80PrYXqx

Answer 1

This may be a problem using the administrative access path for c $. I suggest you go to your [share] server and make the TFSBackup folder a shared folder and grant your resource the appropriate permissions.

Then you can change this:

\\ [share] \ with $ \ TFSBackup

Something like this (depending on what you call your share):

\\ [share] \ TFSBackup $

Answer 2

I know this old post, but just someone else has problems. I had the same problem setting up backups. The following resolved this for me:

1) Open "Services" and pay attention to the user "Login" for "Sql Server" and "Sql Server Agent"

2) In the folder in which your backups are saved, open "Properties" → "Security" → "Edit"

3) Add users from # 1 and check the box "Full Control", "Save"