When I use the UNC to the share drive I get access denied. I gather this is because it is running under the Sql Agent Account and not me. How do I tell the Agent to run under myself? The other problem is, if i run the backup as myself in
the Query Editor it still fails, even though at the bottom it gives my domain\username as who the query is running under.
10.50 RTM Sql Server 2008
View Complete Post