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

Article:TECH43512

Created: 2009-01-16

Updated: 2013-03-18

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

Article Type
Technical Solution

Product(s)

Show all

Languages

Show all

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)