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

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, 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.