What permissions are required for the backup and restore of Microsoft SQL Server databases using the NetBackup for Microsoft SQL Server database agent?
The following roles have permissions to perform backups:
Server Role : sysadmin
DB role : db_backupoperator, dbo_owner
The following roles have permissions to perform restores:
Server role : sysadmin, dbcreator
DB role : db_owner (if the database exists)
Therefore, for backups and restores, the NetBackup Client Service on the client system must be set to logon as a Windows account that is a member of the SysAdmin server role in SQL Server, and any user logging onto the client system to perform backups or restores using the NetBackup MS SQL Client must also be a member of the SysAdmin server role in SQL Server.
See the following Microsoft articles for more information: