SQL Server Performance

Backup Question

Discussion in 'SQL Server 2005 General DBA Questions' started by gujsa01, Jun 6, 2008.

  1. gujsa01 New Member

    I have granted dbo, db_backupoperator role but when this user tries to change the location of the backup folder using SSMS, the following error is displayed:
    The EXECUTE permission was denied on the object 'xp_availablemedia', database 'mssqlsystemresource', schema 'sys'.
    The user does not have permission to perform this action.
    The statement has been terminated. (Microsoft SQL Server, Error: 229)

    Looking into the sys schema persmissions within this database, dbo has access to backup database/log and select permissions.
    Appreciate any help.
  2. Luis Martin Moderator

    But, may be, he don't have permission to change the folder or write.
  3. gujsa01 New Member

    This is a SQL user account. Funny thing is if this user types in the backup folder path and runs the backup process, works fine.
    Issue is when he is trying to clikc the ellipses to display the available drives on this server. Also I confirmed the windows account that this user is logged in with, has access to the backup drive .
  4. Luis Martin Moderator

    Try with one user with SQL Windows authentication. To me that is the problem.
  5. gujsa01 New Member

    Thanks , will try it !!!
  6. MohammedU New Member

Share This Page