Best permissions for backup user for BE agent - SQL server
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?