Grant backup permissions at server level ?

Hi There

The backup database permission seems to only be at a database level , grant backup database and db_backupoperator role only exist at a database level.

However i want to permission to a user to backup any database, and he must not be a sysadmin. I cannot find a server level role that can backup databases.

How can i do this? There are alot of database so granting the permission for every database seems a waste of time, also one would have to remember every time a new database is created to grant this permission.

There must be a way to do this at a server level?

Thanx

In 2005, you can grant CONTROL SERVER, but that would seem too open (almost as bad as sysadmin), so no, you will probably have to add that to your "new database" checklist (or write a procedure that will create the DDL for creating a database and include the GRANT statements/reminder to add GRANT statements.)

They must be really careful with who gets BACKUP privileges, because if you can do a backup, you can do whatever you want with the data in the database.