Minimal permission to backup a SQL 2008 DB using BE 12.5
Posted on 2010-11-12
Currently BE is set up using a domain account having "sysadmin" rights to the DB. Backup runs fine.
I want to see if I can cut back on permissions to only allow this account to have backup and restore otions within the DB.
I granted the login the "dbcreator" server role in case of a restore. I also granted the account "db_backupoperator" and "db_owner" database roles for backup purposes.
When I run the BE backup, I get:
Backup- FRS V-79-65323-3265 -
An error occurred on a query to database Clarity6.
V-79-65323-3265 - The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE.
Is my only option to leave this account with the "sysadmin" server role? Or can I cut back it's power within the database? if so, what permissions do I need?