Re: Backup permission

From: CC&JM (anonymous_at_discussions.microsoft.com)
Date: 06/08/04 

Date: Tue, 8 Jun 2004 04:51:00 -0700

Thanks Tibor,

I use this text to put one post in HP forums but got no
answer.
Other thing that i dont understand is that when a user is
member of the db_backupoperator and use this user to
register in Enterprise Manager(to test backups), when i
need to choose the location for the backup the following
error appear (ERROR 229: Execution permissions denied
on 'xp_availablemedia'...)
I dont understand.

Thanks for eveything

>-----Original Message-----
>No need to start a new thread for this. I replied a few
days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be
sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>
>"CC&JM" <anonymous@discussions.microsoft.com> wrote in
message news:1991601c44d47$0a128860$a501280a@phx.gbl...
>Hello,
>I´ve some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment i´ve one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>
>Best Regards
>
>
>.
>

Relevant Pages

  • Re: Database Backup over the network
    ... The problem is still permissions... ... The file permissions needed for backup are those for the login that sql ... and the permissions are those that SQL Agent uses when the backup ... Wayne Snyder, MCDBA, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Database Backup
    ... Have you checked the actual permissions for the folder? ... Columnist, SQL Server Professional ... > I am trying to backup the database, ...
    (microsoft.public.sqlserver.security)
  • Re: Backup to mapped drive?
    ... Check that the SQL Server service account actually has the proper rights to ... Ownership and permission problems on the backup device's physical file can ... does not check file access permissions. ...
    (microsoft.public.sqlserver.tools)
  • Re: Backup permission
    ... It is likely that the tool vendor need you to be sysadmin, ignoring the fact that SQL Server allow you ... to do backup is you are db_backupoerator. ... that this user have 'Sysadmin' permissions, ...
    (microsoft.public.sqlserver.server)
  • Re: SBS2003, NTBackup-Fehler
    ... Falls das Problem noch verhandeln ist,werde ich vorschalgen nächste Schritte durchzuführen. ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.de.german.backoffice.smallbiz)
Quantcast