2015-01-05 04:09 PM - edited 2015-12-18 01:06 AM
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?