backup and restore role

I need to restrict somebody to do only the backup and restore over a
database. What server role and database permissions I should give to this
user?
Regards
FeiGive db_owner permissions to this specific database. With db_owner
permissions the user will be able to backup and restore this database.
However, it the database being restore does not exist, this user will
require CREATE DATABASE permissions.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Fei" wrote:

> I need to restrict somebody to do only the backup and restore over a
> database. What server role and database permissions I should give to this
> user?
> Regards
> Fei|||Thank you. What server role should I give? I just tried to a restore with
"server administrator" and "db_owner" on the database, I got the permission
denied msg.
Fei
"Ben Nevarez" wrote:
[vbcol=seagreen]
> Give db_owner permissions to this specific database. With db_owner
> permissions the user will be able to backup and restore this database.
> However, it the database being restore does not exist, this user will
> require CREATE DATABASE permissions.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Fei" wrote:
>|||The information I sent below is for SQL Server 2005. In SQL Server 2000
db_owner do not have RESTORE permissions.
Also, in both SQL Server 2000 and 2005, the fixed database role
db_backupoperator has BACKUP but not RESTORE permissions.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"Ben Nevarez" wrote:
[vbcol=seagreen]
> Give db_owner permissions to this specific database. With db_owner
> permissions the user will be able to backup and restore this database.
> However, it the database being restore does not exist, this user will
> require CREATE DATABASE permissions.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Fei" wrote:
>