permission required for a backup operator

I have installed SQL Server 2000 in a Wondows 2000 Server, and I need to set
permissions for a user to only backup data bases to tape media, I have tried
everything without any results, does any one have any clue about this.Have you tried granting BACKUP DATABASE statement permissions? Another
method is to add the user to the db_backupoperator fixed database role.
Hope this helps.
Dan Guzman
SQL Server MVP
"Carlos Caballero" <CarlosCaballero@.discussions.microsoft.com> wrote in
message news:24025B3A-A2AF-4AA3-84AE-0893E76D4A26@.microsoft.com...
>I have installed SQL Server 2000 in a Wondows 2000 Server, and I need to
>set
> permissions for a user to only backup data bases to tape media, I have
> tried
> everything without any results, does any one have any clue about this.|||Dan,
I have fixed the user as an db_backupoperator database role and I still have
the same problem, the thing is that when the operator try to backup the
database he can't use the tape device. I have tried creating a backup device
pointing to the tape but the operator still can't see it. Do you have any
other idea?
"Dan Guzman" wrote:

> Have you tried granting BACKUP DATABASE statement permissions? Another
> method is to add the user to the db_backupoperator fixed database role.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Carlos Caballero" <CarlosCaballero@.discussions.microsoft.com> wrote in
> message news:24025B3A-A2AF-4AA3-84AE-0893E76D4A26@.microsoft.com...
>
>|||What is the exact error message? Any related messages in the SQL Server
error log? Can the user backup to disk?
Hope this helps.
Dan Guzman
SQL Server MVP
"Carlos Caballero" <CarlosCaballero@.discussions.microsoft.com> wrote in
message news:4575CACD-B488-4468-9E76-D0429E8BF231@.microsoft.com...[vbcol=seagreen]
> Dan,
> I have fixed the user as an db_backupoperator database role and I still
> have
> the same problem, the thing is that when the operator try to backup the
> database he can't use the tape device. I have tried creating a backup
> device
> pointing to the tape but the operator still can't see it. Do you have any
> other idea?
> "Dan Guzman" wrote:
>