SQL Maintenance Plan runs automatically, but not manually.

• dfreitag

  SSC Enthusiast

  Points: 187

  More actions

  October 2, 2019 at 7:01 pm

  #3685435

  I am running SQL Server 2008 R2 and have a maintenance plan that creates a backup file every two hours. If allowed to run automatically it runs fine and creates the *.bak file no problem.

  When I try to execute the plan automatically it will say that it was successful in creating the backup, but no actual .bak file gets created. There are no errors generated, it just doesn't actually process the task when the plan is manually executed.

  I am at a complete loss and haven't been able to find anyone else that has had this specific issue.

  Any suggestions?

  Thanks,

  Dirk

  • This topic was modified 5 years, 9 months ago by dfreitag.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  October 2, 2019 at 9:59 pm

  #3685473

  Try running a trace when you execute the package manually to see what is going on.

  Sue