Dump by batch files

KALACHNIKOV Kalach 1 Reputation point


I have a recent problem that I can't solve...

Via batch files (2 per day) I want to dump a database.

The files work well because when I run them my dumps are well created but on the other hand when I want to use the scheduled tasks it does not work, and I cannot find the problem (we had another server with the same version of windows and the same options in scheduled tasks and it worked).

If anyone could give me a hand I would greatly appreciate it.


Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,297 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. MotoX80 32,326 Reputation points

    Configure the scheduled task to execute a .bat file and capture both stdout and stderr to a log file. Add in "dir" commands to verify that the account that the task executes with can see the directories that it is processing.


    0 comments No comments

  2. Limitless Technology 39,436 Reputation points

    Hello there,

    As this issue is with One server alone it seems like a permission-related error. Some tasks will only run when a certain user is logged on, depending on a task's security options. If a scheduled task does not run when you expect it to run, ensure that the task's security options are set correctly.

    A scheduled task, by default, runs within the security context of the user who scheduled the task and only runs if that user is logged on when the task is triggered. To modify this, change the settings in the Security options section of the General tab when a task's properties are displayed.

    Task Security Context



    --If the reply is helpful, please Upvote and Accept it as an answer–

    0 comments No comments

  3. KALACHNIKOV Kalach 1 Reputation point


    Thanks for yours answers, I use the administrator for tasks whis maximal permission, and tasks can run even though the user is not log...


    I will watch for stdout and stderr.

    0 comments No comments