sysadmin server role on the server .
All Programmers are in
dbCreator Server role , So they can create databases for themselves and they have in
db_owner & db_Backupoperator database role for their own databases.
All programmer have remote desktop access to the server just like me . I would like every Programmer be able to backup and restore their own databases .
But When they are trying to restore , in Specifying back-up dialog , when user click on
add button they get this error ( while i can restore ).
C:\Program files\Microsoft SQL Server\mssql10_50.sql2008\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
I appreciate any help .