SQL Server Backup problem when browsing to the directory

Posted by Richard West on Server Fault See other posts from Server Fault or by Richard West
Published on 2010-04-06T16:04:02Z Indexed on 2010/04/06 16:13 UTC
Read the original article Hit count: 406

Filed under:
|

I want to allow a group (eg. 'BackupManagers') who can only preform backup and restore operations on certain databases. When creating the BackupManagers user account I checked db_backupoperator.

When the user logs in to create a backup they get an error message similar to the following when the select Tasks -> Backup -> Click on Add in the destiantion block -> click on the "..." button to browse

TITLE: Locate Database Files - MYSERVER\SQL2005 E:\MSSQL\Backup Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.

I have confirmed that the user has permissions to the folder. I have even created a share to this folder and had them access it through explorer. They are able to create and delete files within the folder.

I have found that if they type in the path to the file instead of using the "..." button to browse the directory tree then they can create a backup file fine.

Why is the browse button not working as expected?

Thanks!

© Server Fault or respective owner

Related posts about sql-server-2005

Related posts about backup