NetBackup for Microsoft SQL Server database agent: What permissions are required for the backup and restore of Microsoft SQL Server databases?

Problem

What permissions are required for the backup and restore of Microsoft SQL Server databases using the NetBackup for Microsoft SQL Server database agent?

 

Solution

NetBackup does not have any authentication requirements beyond Microsoft SQL Server's requirements for the backup and restore of SQL databases.

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:

BACKUP (Transact-SQL) 

RESTORE (Transact-SQL)


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)