BackUps not deleting

From: Craig HB (CraigHB_at_discussions.microsoft.com)
Date: 03/31/05


Date: Thu, 31 Mar 2005 00:31:02 -0800

I am backing up databases on SQL Server 2000 using a database maintenance
plan. I have set it to remove files older than 1 day (for both the database
and transaction log backups). This used to delete the old backup files, but
now it just backs up, without deleting anything.

Any help would be appreciated,
Craig



Relevant Pages

  • Is this some structural problem?
    ... Since upgrade, we have seen some strange behavior. ... We have witnessed exceedingly large database restoration timings. ... transaction log backups till I cleaned the drive and took a full backup. ...
    (microsoft.public.sqlserver.server)
  • Re: log shipping failover to stand by server
    ... Disables the log-shipping transaction copy job on the standby server. ... Restores all transaction log backups not previously restored to the ... standby database and initiates the recovery of the standby database. ...
    (microsoft.public.sqlserver.replication)
  • RE: Maintenance Plan for Transaction Logs is failing
    ... >Is the database is full recovery mode (not simple or bulk ... >> transaction log backups is failing. ... The plan for the ... While the actual production database is set to Full, ...
    (microsoft.public.sqlserver.setup)
  • Re: Recovery from Delete statement using the transaction logs
    ... If you did, just do ROLLBACK. ... Are you performing regular transaction log backups? ... Is database in full or bulk logged recovery ...
    (microsoft.public.sqlserver.server)
  • Bizarre data loss running maintenance plan
    ... Apparently the transaction log backups have ... been failing because the database is set to the Simple recovery model. ... I'm losing updates to records that were updated prior to the ...
    (microsoft.public.sqlserver.msde)