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?....
  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?....
