Hello:

We are on SQL 2005 9.00.4035. We have had a maintenance plan that backs up
our databases at midnight every night.

Yesterday, we changed this plan to backup at 10PM instead of 12AM.

The backups at 10PM were successful last night, and SQL Activity Monitor
says that the plan will run again at 10PM tonight.

But, the backups, also occurred at 12AM. So, we got two backups last
night--one at 10PM and one at 12AM!

I'm a firm believer in the more backups, the better. But, we really
can't have two backups the same night as it fills up space on the server's
hard drive.

I do not see any reason as to why this would have happened. Any ideas as to
how to prevent the backups from happening at 12AM again?

SQL Programmer (it's just a name)

SQL Programmer,

Maintenance Plans actually create SQL Agent jobs to run the plan on
schedule. I would check the SQL Agent jobs to see if, after changing the
schedule for the plan, you now have two SQL Agent jobs for the maintenance
plan, one at 10:00 PM and one at 12:00 AM.

The SQL Agent jobs are named similarly to the maintenance plan, so you
should be able to find if you have two similar jobs. If that does not
help, then in SQL Server Management Studio you go to the SQL Server Agent /
Jobs node and select View History. This will give you the history for all of
your jobs merged together. Scroll down to look at what was running at 10:00
PM and 12:00 AM.

I am pretty sure that you will find one job to delete.

RLF

"SQL Programmer" <SQLProgrammer (AT) discussions (DOT) microsoft.com> wrote

No, here's what happened. It's a classic case of "boy, I feel stupid".

The backup job from the previous "midnight" is still in the folder. It
shows 09/01/09. And, the 10PM job also shows 09/01/09. If the backup job
were really running twice, the midnight file would have been dated 09/02/09!

So, I was incorrect. It's not running twice!

When I saw the decrease in space, I jumped to conclusions.

I apologize, for the bother!

SQL Programmer (it's just a name--as you can tell..ha!)




"Russell Fields" wrote:

Live and learn.

"SQL Programmer" <SQLProgrammer (AT) discussions (DOT) microsoft.com> wrote