When doing a backup and restore via native SQL Server backup, it only requires the user to have dbcreator server role and dbo of database.
When using Litespeed xp_xxxx procedures, when trying to do a restore, the following error is shown if the user has the above roles:
'SQL Server has returned a failure message to LiteSpeed for SQL Server which has prevented the operation from succeeding.
The following message is not a LiteSpeed for SQL Server message. Please refer to SQL Server books online or Microsoft technical support for a solution:
RESTORE DATABASE is terminating abnormally.
The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE.'
This is a Microsoft restriction, rather than a LiteSpeed one.
Microsoft's API for 3rd parties requires sysadmin. All third party vendors have this same requirement.
The user does need sysadmin rights to perform a backup or restore. As Litespeed is a 3rd party component, it uses Microsofts VDI interface to perform these tasks. In turn, this needs a user with sysadmin permissions to be granted.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center