The script creates minimum rights Backup Restore Role User /Operator DB for SQL Server 2008.

Using the script minimal permissions are needed for backup and restore operations by the User / Operator created.

 

Following are permissions:

At SQL Server instance following roles are to assigned:

dbcreator
public

 

Using Selected Database following roles are to assigned:

db_backupoperator
db_denydatareader
public

 

As a result user/operator created has minimal permissions for db access.