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

Problem

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 Message

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"
 
 
 

 

 

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)