10-02-2016 05:18 AM
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?
Solved! Go to Solution.
10-03-2016 01:01 AM
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
10-02-2016 01:37 PM
10-02-2016 10:05 PM
but that is just like making an exact copy of the "sa" account. is there an official documentation from Veritas regarding this?
10-02-2016 10:31 PM
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
Refer to Section 3, in particular these two sub-sections:
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
10-03-2016 01:01 AM
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