Video Screencast Help

Best permissions for backup user for BE agent - SQL server

Created: 26 Aug 2013 • Updated: 29 Aug 2013 | 3 comments
This issue has been solved. See solution.

Hello, I'm running BE 2012 with a SQL server agent to backup a production database on SQL Server 2005.

I want to assign the appropriate permissions for the account that will perform the backup. I'm using a domain account, not a database account. There are a number of roles that seem to overlap. My first guess was to use db_backupoperator, but I heard that that lets you backup the database but not restore it (which makes it totally useless). 

Can someone explain what the correct permissions I need to set for it to backup the databases and perform a restore, should a restore ever be needed? 

Thank you.

Operating Systems:

Comments 3 CommentsJump to latest comment

CraigV's picture


The links below should point you in the right direction for the rights required by the BESA: (will show you for SQL) (general rights for the BESA)


Alternative ways to access Backup Exec Technical Support:

CWTokyo's picture

Thank you both, CraigV and Jaydeep S. I think the very first link from Craig was exactlty what I was looking for, but I will check them all out for more information.

Thanks again.