SQL Server 2005 jobs running twice in a row - using LiteSpeed

Posted by Malnizzle on Server Fault See other posts from Server Fault or by Malnizzle
Published on 2010-04-07T16:32:22Z Indexed on 2010/04/07 16:43 UTC
Read the original article Hit count: 616

Howdy!

I have a SQL server (2005) backing up to a network share, who has a group of maintenance plans setup through LiteSpeed to backup different DBs. They were just set up to run two sub plans on different schedules for full/diff backups and did that just fine for a couple of months.

Then I added "Clean Up" task to the subplans. Ever since that point, the backup creates another bak right after the first bak job is completed. I removed the clean up item from the subplan, and it still creates two baks when ran.

Both the SQL Activity Monitor and the machine's windows application log show just one job being executed.

I did this same thing to a couple of other servers backing up to the same location, and they are behaving correctly.

Thoughts?

© Server Fault or respective owner

Related posts about sql-server-2005

Related posts about sql-server