backups running twice

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: SQL Programmer <SQLProgrammer@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 2 Sep 2009 05:17:02 -0700

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)
.

Follow-Ups:
- Re: backups running twice
  - From: Russell Fields

Prev by Date: RE: SQL SERVER DATABASE CREATION ERROR'S
Next by Date: SQL Server 2005 x64 Install on Nehalam based Windows 2008 server
Previous by thread: Data - Log file locations
Next by thread: Re: backups running twice
Index(es):
- Date
- Thread

Relevant Pages

Re: The nightmare begins...
... If you really want high reliability you're talking RAIDs and mirrored drives and sometimes even RAM disks, before you ever get to backups. ... With ESS, you can now add SQL tables directly to the relationship graph, so that more than standard queries are available. ... they use excel for database application. ... where the spreadsheet does learn database operations. ...
(comp.databases.filemaker)
Re: Backup software for SBS2003 Standard
... I configured my test server with Windows Server 2003 and SCE, which runs on a SQL or MSDE database. ... As you say, I'd continue to do the online Exchange backups, maybe to file so they're included in the SP backups. ... For databases I care about, I do Enterprise Manager backups to file a few times a day, and those get included in the SP backups as well. ...
(microsoft.public.windows.server.sbs)
Re: backups running twice
... SQL Programmer ... Maintenance Plans actually create SQL Agent jobs to run the plan on ... > The backups at 10PM were successful last night, ...
(microsoft.public.sqlserver.setup)
Re: restoring a portal
... > If you are using SQL Server as the Database back end, ... > existing Databases assocoated with Portal, ... > SQL backups running you could also try to restore fro SQL also. ...
(microsoft.public.sharepoint.portalserver)
Re: Recover historic databases
... BULK INSERT,bcp or DTS. ... event entirely dedicated to SQL Server, ... > want to archive historic databases to recover it if necessary. ... but I had problems restoring backups when I had updated the ...
(microsoft.public.sqlserver.security)