Forums

This topic is locked

SQL Server BackUp

Posted 23 years ago
1
has voted
23 years ago Viktor Farcic posted:
I have a problem with DB backup on SQL Server. When I go to backup options, click add Add (Destination) and then '...' to choose where to save backup there's following error:
***
Error 229: EXECUTE permission denied on object 'xp_availablemedia', database 'master', owner 'dbo'.
***
If I try to insert path manualy there isn't any error message, but simply it doesn't backup anything.

I suppose that I'm doing something wrong. Can anybody explain me what should be procedure to backup SQL Server database from host to my local HD?


Replies

Replied 23 years ago
23 years ago Joel Martinez replied:
simply what the error message says, you don't have permision to do it...
you need to be part of the <b>db_backupoperator</b> role to do this...
have the DBA look at it

----------
Is this thing on?....

Reply to this topic