> dump database sybsecurity
to "<destination_here>"
> go
Msg 10331, Level 14, State
1: Server 'SID', Line 1: Permission denied, database sybsecurity, owner dbo.
You need the following permission(s) to run this command: DUMP DATABASE, OWN
DATABASE or MANAGE AUDITING.
Resolution
Add the third party user to the
master database by connecting as user 'sapsso'
(sample scripts for "commvault"
user for "commvault" login id which is already created):
isql -S<SID> -Usapsso -X
>use master
>go
>sp_adduser commvault
>go
Grant those privileges to the
third party user (always connected as user 'sapsso'):
>grant manage security
permissions to commvault
>go
>grant dump database on
sybsecurity to commvault
>go
You may test a
"manual" backup by running this:
isql -S<SID> -Ucommvault
-X -w1000
>dump database sybsecurity
to "<complete_directory_and_filename_here>"
>go