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:TECH68586  |  Created: 2009-01-09  |  Updated: 2012-06-29  |  Article URL http://www.symantec.com/docs/TECH68586
Article Type
Technical Solution


Issue



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



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



Legacy ID



320803


Article URL http://www.symantec.com/docs/TECH68586


Terms of use for this information are found in Legal Notices