How can we help you today? How can we help you today?

Minimum Permissions for Login Used to run Backups

I have recently taken over the administration of my company's implementation of SQL Backup. In our current configuration, we have created a SQL Server login to run the backups. This login has been assigned to the "sysadmin" fixed server role.

I would prefer a configuration that did not require a login with sysadmin privileges. Is there a way to configure the product to use a non-sysadmin login?
Wyatt70
0

Comments

2 comments

Sort by
  • petey
    Not in version 3. To use the VDI interface, the user issuing the BACKUP ... TO VIRTUAL DEVICE = ... command needs to be a member of the sysadmin fixed server role. This is a requirement from the SQL Server engine itself.
    petey
    0
  • Wyatt70
    Okay, that confirms what I experienced. I tried running the backup without sysadmin privileges and I received an error message about the inability to use a virtual device without being a member of sysadmin. I just wanted to ask people who have been using the product for a while if there was any workaround for that issue.

    Thanks for your assistance.
    Wyatt70
    0

Add comment

Please sign in to leave a comment.