Data Backup and Recovery Discussions

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

Re: smsql sql agent backup

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.

Earn Rewards for Your Review!
GPI Review Banner
All Community Forums
Public