Forum Discussion

manatee's avatar
manatee
Level 6
8 years ago

what "sa" privileges are required for another sql account

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?

4 Replies

  • You must need to have "sysadmin and security " privileges for the account you create to backup SQL db's
    • manatee's avatar
      manatee
      Level 6

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

      • Systems_Team's avatar
        Systems_Team
        Level 6

        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_AdminGuide_MSSQL_Win.pdf?__gda__=1475615887_4c81d318969b778af1773aff55b77eff

        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