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-10-28  |  Article URL http://www.symantec.com/docs/TECH43512
Article Type
Technical Solution


Issue



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)




Legacy ID



278882


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


Terms of use for this information are found in Legal Notices