topic Re: schedule backup fail wit sql agent job in Data Protection

schedule backup fail wit sql agent job

sdstorage — Wed, 04 Jun 2025 23:41:33 GMT

all my job of backup fail.... [windows 2012 Alwayson sql server 2014]

in the event viewer i see

The operation executed with the following results. Details: An Unexpected Error occured while executing new-backup. Details: A command that prompts the user failed because the host program or the command type does not support user interaction. The host was attempting to request confirmation with the following message: Please check the results of the Input validation above. Do you still want to continue with the backup anyway Stack Trace: at System.Management.Automation.Internal.PipelineProcessor.SynchronousExecuteEnumerate(Object input, Hashtable errorResults, Boolean enumerate) at System.Management.Automation.PipelineOps.InvokePipeline(Object input, Boolean ignoreInput, CommandParameterInternal[][] pipeElements, CommandBaseAst[] pipeElementAsts, CommandRedirection[][] commandRedirections, FunctionContext funcContext) at System.Management.Automation.Interpreter.ActionCallInstruction`6.Run(InterpretedFrame frame) at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)

if i run the command with powershell or command it works

i use a domain account for agent account

Re: schedule backup fail wit sql agent job

GidonMarcus — Fri, 24 Jul 2015 16:14:57 GMT

When you run it in PS. is it asking you for anything?

what command you are running?

you can try adding something like '-force'or '-errorAction silently continue'

Re: schedule backup fail wit sql agent job

sdstorage — Mon, 27 Jul 2015 07:42:29 GMT

if i run with my user in powershell work like if i change the account of agent to my account

if i use the agent (domain user) not work

if i use the agente domain user in group of administrator not work

the command is

SmsqlJobLauncher.exe new-backup –svr 'MSSQL' -ag 'MSSQAG' -prm -ver -bp 1,99 –verInst 'mssql03' -mp –mpdir 'C:\SMSQLMnPt' -RetainBackups 2 -RetainShareBackups 7 -cpylgbkshare NOTHING_TOSHARE -lb -bksif -RetainSnapofSnapInfo 2 -rudays 1 –mgmt daily -db

the option force not work

seem problem of permission but why? the agent are administrator....

Re: schedule backup fail wit sql agent job

GidonMarcus — Mon, 27 Jul 2015 07:56:54 GMT

Could be that UAC trying to kick-in or there another way the exe tries give an error to the screen, unfortunately i currently don't have the environment to test.

Do you realize this is not a powershell command right? (Just an exe with parameters). Is running it from CMD giving the same result?

Re: schedule backup fail wit sql agent job

sdstorage — Mon, 27 Jul 2015 08:01:20 GMT

yes with cmd i receive the same result withe the agent user

Re: schedule backup fail wit sql agent job

Anthony_Log — Thu, 19 Nov 2015 23:31:00 GMT

It is a SMSQL command that is run in SMSQL Powershell.

Re: schedule backup fail wit sql agent job

Anthony_Log — Thu, 26 Nov 2015 00:06:17 GMT

I have identified the problem.

The Agent account on the source server is different from the destination server. By adding both users to the local administrators group on each server the problem was resolved.