SharePoint Database backup fails with error "The login has insufficient authority"

Article:TECH76083  |  Created: 2009-01-27  |  Updated: 2011-03-30  |  Article URL http://www.symantec.com/docs/TECH76083
Article Type
Technical Solution


Issue



SharePoint Database backup may fail with error " V-79-57344-33938 - The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE"


Error



V-79-57344-33938 - An error occurred on a query to database . V-79-57344-33938 - The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE.


Solution



The above error occurs in the job log while backing up SharePoint databases if the user account used does not have proper rights.  To resolve this issue follow the steps given below:
 

 
1. On the server which has the SharePoint databases installed ,open the Microsoft SQL Server Management Studio and connect to the SharePoint Database Instance.
 

 
2. Right Click on "Security" and select New =>  Login
 
 
 

 
3. On the "Login-New" window enter the Login name (Backup Exec Account )
 
 
 

 
4. On "Select a page" option  select "Server Roles"
 
 
 

 

 

 

Supplemental Materials

SourceUMI
Value V-79-57344-33938
Description

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

 



Legacy ID



336316


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


Terms of use for this information are found in Legal Notices