Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ashgupta
Starting Member
17 Posts |
 Posted - 2009-05-22 : 00:26:52
|
| I granted the 'dbcreator' server right to the NEW_USER user2. We mapped the NEW_USER to the DatatBase_A and defined the Database role membership for DataBase_A with Public and db_backupoperator However, when the NEW_USER try to backup or restore the DataBase_A, it prompt ''C:\Program Files (x86)\SQL2005 64bit\MSSQL.1\MSSQL\Backup\' cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the parth 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. |
|
|
|
|
|
Setint up User Access Right To A BackupOperator