Best permissions for backup user for BE agent - SQL server

[CWTokyo]

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.

[CraigV · Accepted solution]

Hi,

The links below should point you in the right direction for the rights required by the BESA:

http://www.symantec.com/business/support/index?page=content&id=TECH66396

http://www.symantec.com/business/support/index?page=content&id=TECH130255 (will show you for SQL)

http://www.symantec.com/business/support/index?page=content&id=TECH23689 (general rights for the BESA)

Thanks!

[Jaydeep_S · Accepted solution]

This should help

http://www.symantec.com/docs/TECH130255

http://www.symantec.com/docs/HOWTO74429

[CWTokyo]

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.