Removing old transaction log backup files

From: AscentSQLAdmin (AscentSQLAdmin_at_discussions.microsoft.com)
Date: 08/27/04 

Date: Fri, 27 Aug 2004 11:01:04 -0700

My organization is running SQL Server 2000 on a Windows 2000 server. We have
a maintenance plan set up to perform a daily backup of several database
files. The full database backup runs each day at 2:00 a.m. The transaction
log backup runs every four hours. It is setup in the maintenance plan that
the checkbox for both the data file and transaction log that says "Remove
files older than" is checked and set for 2 days. However, the old transaction
log backup files (*.TRN) are not being automatically removed. The regular
database files (*.BAK) are removed just fine. Any suggestions?

Relevant Pages

  • Re: Event log error message: Database log truncated: Database
    ... our maintenance plan combines both master and the User ... It also selects Transaction Log Backup option. ... back up the database as part of the maintenance plan and etc) ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2008 Workgroup Scheduled Backup
    ... the "Execute SQL Agent Job" is just showing you the command to use in a SQL Agent job to start another job. ... You have to design your plans, for example, depending on your database sizes, retention of backups, recovery models, how critical a database is, et cetera: ... Database Differential Backup - daily ... I cannot execute a maintenance plan in this version because it does not come with SQL Integration Services.so I'm trying to setup a scheduled job in SQL Server Agent. ...
    (microsoft.public.sqlserver.server)
  • Re: Event log error message: Database log truncated: Database
    ... our maintenance plan combines both master and the User ... It also selects Transaction Log Backup option. ... Select Recovery mode Simple for master. ... Select all options (Reorganize data and index pages, check database ...
    (microsoft.public.sqlserver.server)
  • Re: Event log error message: Database log truncated: Database
    ... I think this event log is related to the way we create our maintenance plan ... Backup always failed under the SQL Server Agent Jobs list. ... Select Recovery mode Simple for master. ... Select all options (Reorganize data and index pages, check database ...
    (microsoft.public.sqlserver.server)
  • Re: How to create maintenance plan to backup files and filegoups
    ... > take long time to backup the whole database. ... > separate filegroup to reduce to time of the backup? ... >>You can't use the Maintenance Plan to perform backups ...
    (microsoft.public.sqlserver.server)