SQL Backup without sysadmin
tomslickers
Posts: 40 Bronze 2
in SQL Backup
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?
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
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com