up vote 0 down vote favorite
share [g+] share [fb]

I have a scheduled backup that should run once per day, but runs twice. I've scheduled the job to run at 6:30 AM, daily.

If I view the log of that maintenance plan, I can see that it ran today at 5:00 and at 6:20.

If I view the Job History log, it shows that the backup was run once, at 6:20 only.

This job was scheduled to run at 5:00, but was rescheduled to 6:20. I deleted the 5:00 schedule and replaced it with the 6:20 one under the maintenance plan. I've confirmed that only one job is added for this under SQL Server Agent visually under SSMS as well as querying the sysjobs table and the sysjobsteps table.

I'm not sure what the next step might be to track this down is.

link|improve this question
feedback

1 Answer

up vote 2 down vote accepted

Three things I would suggest:

  1. Look at the schedule for the maintenance plan and verify the time and recurrence for the maintenance plan.

  2. Look at the steps in the maintenence plan to make sure there aren't two backup steps.

  3. Delete the maintenance plan and create a new one.

link|improve this answer
Those are all good steps, and they are ones that I tried but ended up not being the solution. It ended up being a clone of the VM that was made that never had the backup scripts terminated, so the second machine was running them via its SQL Server Agent. – Dan Bowling Aug 1 '11 at 21:01
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.