Backup Permissions

Hi,
The user that i use to make backups is in the
db_backupoperator, but when i select the backup
destination the following error appear:
ERROR 229: EXECUTE permission denied on
object 'xp_availablemedia', database 'master', owner 'dbo'
cant understand
Beat regardsHi
An what are the permissions on this stored procedure?
John
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18f4301c44c93$2caec050$a301280a@.phx
.gbl...
> Hi,
> The user that i use to make backups is in the
> db_backupoperator, but when i select the backup
> destination the following error appear:
> ERROR 229: EXECUTE permission denied on
> object 'xp_availablemedia', database 'master', owner 'dbo'
> cant understand
> Beat regards|||Hi,
Open query analyzer and execute the below command:-
master..xp_availablemedia
Check the drives, the command is displaying. Based on this create the backup
files. I think you are trying to backup to a remote server or a media not
available. If the execution gives you an error try giving execute prev to
this extended procedure to your backup user.
use master
go
sp_adduser <user_name>
go
grant exec on xp_availablemedia to <user>
(Try executing backup database now)
Still if you have errors then try below:- Can you please assign "SYSADMIN"
server fixed role to this user and try backup the database.
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:18f4301c44c93$2caec050$a301280a@.phx
.gbl...
> Hi,
> The user that i use to make backups is in the
> db_backupoperator, but when i select the backup
> destination the following error appear:
> ERROR 229: EXECUTE permission denied on
> object 'xp_availablemedia', database 'master', owner 'dbo'
> cant understand
> Beat regards