Data Backup and Recovery

smsql sql agent backup

_NETAPPUSER

I created SMSQL scheduled backup job throught the SQL Agent. The snapdrive service account was used for the SQL Agent backup job and the default schema for that account on SQL is dbo. IA (information assurance) folks did not like the dbo beacuse it has too much priviledge. Can a lower priviledged schema be applied and still allow the scheduled Agent backup to work?

1 REPLY 1

dmauro

Hello,

SMSQL requires to run with a user which is sysadminon each managed SQL instance and it requires that user to be a local admin.

hope that clarifies it.

Domenico.

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public