SQL backup fails with error "The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE" even though the user has sysadmin permission to the database in SQL 2005

  • Article ID:100020397
  • Modified Date:
  • Product(s):

Problem

SQL backup fails with error "The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE" even though the user has sysadmin permission to the database in SQL 2005

Error Message

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

Cause

This issue is caused due to insufficient permissions to the backup account on the sql instance.

Solution

To fix this issue, make sure that the user has 'sqladmin' and 'sqlserveradmin' rights in SQL Management Studio 2005
  1. Launch the SQL Management Studio Console and go to Security-->Logins.
  2. Identfy the User that is used in Backup Exec to backup SQL 2005 Databases.
  3. Right click the User and go to Properties
  4. Select Server Roles
  5. Select serveradmin and sysadmin
  6. Rerun the backup of the SQL database

Related Articles

"Access is denied" errors occur when attempting to backup SQL Databases

Was this content helpful?

Get Support