SQL Backup without sysadmin

We're trying to get SQL Backup working using an account that is not sysadmin. The account is db_owner in all databases. We added SkipChecks=1 to HKEY_LOCAL MACHINE\Software\Red Gate\SQL Backup\BackupSettingsGlobal(LOCAL), but now we get the following:

The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE

Is is possible to use SQL Backup without sysadmin rights?


Tagged:

Answers

  • Hi, thank you for your forum post.

    Sadly the account you provide to the SQL Backup Agent service needs to be a member of the sysadmin fixed server role.  It is a requirement from SQL Server for SQL Backup to be able to generate the Virtual Device Interface (VDI) used in the backup process.

    This means, if you are unable to provide sysadmin rights, your backup and restore tasks using SQL Backup will not be successful.

    Many Thanks
    Eddie
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.