SQL agent backup or restore may fail with the error "V-79-65323-3265 :The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE."
Article ID: 100023122
Updated On:
Description
Error Message
V-79-65323-3265 :The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE
Resolution
To backup and restore databases using Backup Exec the account used for backup must be given sysadmin rights for the databases that are getting backed up with the Microsoft SQL Agent.
Please review the SQL documentation for instructions on adding user right assignments in Microsoft SQL Server.
Please review the SQL documentation for instructions on adding user right assignments in Microsoft SQL Server.
Issue/Introduction
While performing a SQL agent backup or restore, the following error occurs : "The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE"
Additional Information
UMI: V-79-65323-3265
Was this article helpful?
Yes
No
Powered by
