Maintenance Plan

I'm running an SBS2000 server with SQL serving up about 20 small databases.
I have a maintenance plan in place that runs every night backing up each of
the databases to a folder which in turn gets backed up by tape two hours
later. I have the plan configured to delete transaction logs and database
files older than 2 days. The backups are running fine, but the plan is not
deleting the old backup files and transaction logs.I have had that issue in the past and found that the
backups don't always complete at the same time. If you
setup a maintenance plan to remove backups older than 1
day and you do the following;
You had the 1st backup run and complete at 12:04.
The next day, the backup is a little quicker and finished
at 12:03. The backup from the previous day won't be
deleted as a FULL 24 hours haven't passed. I modified my
setting to delete after 23 hours.
Hope this helps.
Thanks
Fred
>--Original Message--
>I'm running an SBS2000 server with SQL serving up about
20 small databases.
>I have a maintenance plan in place that runs every night
backing up each of
>the databases to a folder which in turn gets backed up by
tape two hours
>later. I have the plan configured to delete transaction
logs and database
>files older than 2 days. The backups are running fine,
but the plan is not
>deleting the old backup files and transaction logs.
>.
>|||Could be that you have included databases for log backup that are in simple
recovery mode.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"RScott" <anonymous@.discussions.microsoft.com> wrote in message
news:0E5C4CEC-1C97-4ADB-8D5E-97F549E0C495@.microsoft.com...
> I'm running an SBS2000 server with SQL serving up about 20 small
databases.
> I have a maintenance plan in place that runs every night backing up each
of
> the databases to a folder which in turn gets backed up by tape two hours
> later. I have the plan configured to delete transaction logs and database
> files older than 2 days. The backups are running fine, but the plan is
not
> deleting the old backup files and transaction logs.sql