cancel
Showing results for 
Search instead for 
Did you mean: 

what "sa" privileges are required for another sql account

manatee
Level 6

NBU 7.6.0.3

if i don't want to use the "sa" account, what privileges should be provided (official ones as per Veritas because our audit asking) when creating a sql user meant only for backing up sql databases?

1 ACCEPTED SOLUTION

Accepted Solutions

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

you need sysadmin role. However, it is not Veritas, but Microsoft requirement. See this link:

https://support.microsoft.com/cs-cz/kb/2926557

(So consequently, all third-party backup vendors supporting MS SQL db backup require this.)

Michal

View solution in original post

4 REPLIES 4

P_Kesavan
Level 4
Certified
You must need to have "sysadmin and security " privileges for the account you create to backup SQL db's
Kesavan.P

but that is just like making an exact copy of the "sa" account. is there an official documentation from Veritas regarding this?

Systems_Team
Moderator
Moderator
   VIP   

Hi Rino19ny,

As per normal, this is documented in the "NetBackup for Microsoft SQL Server Administrator's Guide".  You have tagged your post as NetBackup 7.6, so I am guessing that is the version you are running.  The link for the manual is:

Symantec NetBackup 7.6 for Microsoft SQL Server Administrator's Guide

https://download.veritas.com/resources/content/live/DOCUMENTATION/6000/DOC6479/en_US/NetBackup_Admin...

Refer to Section 3, in particular these two sub-sections:

  • About SQL Server security and NetBackup  (Page 25)
  • Configuring the NetBackup services for SQL Server backups and restores  (Page 26)

If you are using or thinking of using VMware Intelligent Policies to backup SQL, then you should also refer to the NetBackup for VMware Administrator's Guide, but the link I've provided should give you all you need if it is a standard SQL backup.

Hope this helps,

Steve

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

you need sysadmin role. However, it is not Veritas, but Microsoft requirement. See this link:

https://support.microsoft.com/cs-cz/kb/2926557

(So consequently, all third-party backup vendors supporting MS SQL db backup require this.)

Michal