Forums

This topic is locked

SQL Server BackUp

Posted 28 Jun 2001 19:25:56
1
has voted
28 Jun 2001 19:25:56 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 06 Jul 2001 19:00:39
06 Jul 2001 19:00:39 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