How to create backup role on SQL 2008 R2

The minimum rights for backup/restore on SQL server 2008R2 are these:

Server roles:
dbcreator
public

Database roles:
db_backupoperator
db_denydatareader
public

 

This is an example of error when some rights are missing when BACKUP EXEC try to backup SQL:

Login failed for user ‘[DOMAIN]\backup_service’. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]

 

Advertisements

One thought on “How to create backup role on SQL 2008 R2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s