asked on

Which MS SQL Server's service account executes a backup job in a remote disk?

Hello:

I'm using SQL Server 2017 and have a doubt regarding which service really executes the jobs when remote devices are implied.

When I create a maintenance plan, this including a job, and the plan is executed, I know it is the Agent Service which executes the job.

My doubt concerns operations performed on a remote disk, for example a job with a backup in a network disk. Is it the Agent Service Account to which write permissions must be granted on the remote disk, or is it the Database Engine Service (MSSQLServer)?

Some link to documents regarding these issues, permissions, execution accounts, etc.,will be welcome.

Thanks in advance,

Juarrero

SOLUTION

Darrell Porter

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Raja Jegan R

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Vitor Montalvão

Marking my comment as solution as Darrell's and Raja's as assisted answers because I think I gave the correct explanation on how the SQL Agent jobs work in terms of permissions and the other comments has links that supports how SQL Agent works.
Darrell and Raja, if you don't agree with my recommendation, please justify and suggest other closure option.