Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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

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!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

SOLUTION
CWTokyo's picture

Thank you both, https://www-secure.symantec.com/connect/sites/defa...); padding-right: 27px; margin-right: 3px; font-weight: bold; line-height: 15px; color: rgb(65, 110, 0); font-family: helvetica, arial, clean, sans-serif; font-size: 12px; background-position: 100% -75px; background-repeat: no-repeat no-repeat;">CraigV and https://www-secure.symantec.com/connect/sites/defa...); padding-right: 27px; margin-right: 3px; font-weight: bold; line-height: 15px; color: rgb(65, 110, 0); font-family: helvetica, arial, clean, sans-serif; font-size: 12px; background-position: 100% -60px; background-repeat: no-repeat no-repeat;">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.