Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am trying to create a backup plan using the TFS Power Tools but I keep running into this error message: TFS Backup Error

I have checked that the account has Full Control on the share, I can edit, create and delete files there. From the log:

[Info   @07:15:00.403] Starting creating backup test validation
[Error  @07:15:00.700] Microsoft.SqlServer.Management.Smo.FailedOperationException: Backup failed for Server 'WMSI003714N\SqlExpress'.  ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Cannot open backup device '\\wmsi003714n\sql dump\Tfs_Configuration_20100910091500.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 1815).
BACKUP DATABASE is terminating abnormally.
   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
   at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSql(Server server, StringCollection queries)
   at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Management.Smo.Backup.SqlBackup(Server srv)
   at Microsoft.TeamFoundation.PowerTools.Admin.Helpers.BackupFactory.TestBackupCreation(String path)
[Error  @07:15:00.731] !Verify Error!: Account GROUPINFRA\SA-NO-TeamService failed to create backups using path \\wmsi003714n\sql dump
[Info   @07:15:00.731] "Verify: Grant Backup Plan Permissions\Root\VerifyDummyBackupCreation(VerifyTestBackupCreatedSuccessfully): Exiting Verification with state Completed and result Error"

Any ideas?

share|improve this question
1  
There are two sets of permissions in play. The share permissions and the file system permissions. The most restrictive prevail. It sounds like your account GROUPINFRA\SA-NO-TeamService may not have file system level permissions. –  BillP3rd Sep 10 '10 at 7:24

6 Answers 6

up vote 5 down vote accepted

I had the same problem and noticed that your share name "sql dump" has a space in it, just like mine. I removed the space character and it worked fine!!

share|improve this answer
    
Yep, it's a bug. I've raised it with the team and it will be addressed in a future version of the power tools. –  Grant Holliday Apr 20 '12 at 13:06
    
There goes another hour of my life... –  Ted Dec 21 '12 at 16:24

Does the account you are using to run the backup also have full control (or at least write) on the file system folder that is shared (i.e. both share and folder permissions allow writing)?

Remember that the account creating the job isn't necessarily the account running it (this might not apply as, IIRC, Power Toys backup doesn't use SQL Agent).

Try monitoring the destination with Process Monitor to see if it is a failure in SQL Server (i.e. fails before any file create/write) or in writing.

share|improve this answer
    
Yes, the current user and the account used for backup both has full control on the share. I'll try Process Monitor once I get back into the office on Monday. Thanx for the suggestion. –  noocyte Sep 11 '10 at 14:18

For me it was the Share permissions not being as explicit as the FS permissions. I had all the accounts setup on the directory, but once I fixed the share then I was all set and the tests passed.

share|improve this answer

Make sure you don't have any special characters or spaces in the backup folder path .. in this case (sql dump) has a space in it, I removed the space character and it should work or else make sure the folder has permissions - you can change the login credentials in the Account tab .

share|improve this answer
1  
If you look at the answer, it's the space thing that was the problem... –  noocyte Jan 27 '12 at 8:41

Not related to this specific special character problem, but I had exactly the same error when trying a least-privilege approach. I had to add the account used for the backup to the Backup Operator local Windows group. Hope it helps other people reading this thread.

share|improve this answer

My solution was.

  1. create a share with everyone permission on it
  2. then in folder security you select Everyone account and REMOVE any rights that will let someone to write there !

In this way even someone connects to this new share that TFS will use will not be able to modify. Maybe it a good idea also to create a hidden share (I mean myshare$).

You could inspect what permissions creates and what TFS want's creating In this way and modified and testing. You will surely find what he needs to inspect a file inside.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.