Maintenance Plan

I created a simple Maintenance Plan that backup my
Database every 12 hour and backup the log every 6 hour
so it's created 2 Jobs
al;l the time I am getting an error the the Maintenance
Plan failed
the plan created the backup files (*.bak) but not the log
why ?
w2000+ SP3+SQL7.4
error in the event viewer
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance
Plan 'DB Maintenance Plan1''
(0x98D3C40024DF964584FEBD0E4F8E9782) - Status: Failed -
Invoked on: 7/16/2003 7:34:14 PM - Message: The job
failed. The Job was invoked by User
COMPAQ\Administrator. The last step to run was step 1
(Step 1).Are you logging the transactions? In SQL 7 that means
the "truncate log on checkpoint" is NOT on, in SQL 2000 a
Simple Recovery plan will not log transactions. Also, the
Select/into bulk copy setting, if on, will allow someone
to do certain commands which will make the log backup
fail. Have to check those and look into why the option is
needed to be set on if it IS... or a log backup device is
blocked by something like a tape backup job?!? Bruce
>--Original Message--
>I created a simple Maintenance Plan that backup my
>Database every 12 hour and backup the log every 6 hour
>so it's created 2 Jobs
>al;l the time I am getting an error the the Maintenance
>Plan failed
>the plan created the backup files (*.bak) but not the log
>why ?
>w2000+ SP3+SQL7.4
>error in the event viewer
>SQL Server Scheduled Job 'DB Backup Job for DB
Maintenance
>Plan 'DB Maintenance Plan1''
>(0x98D3C40024DF964584FEBD0E4F8E9782) - Status: Failed -
>Invoked on: 7/16/2003 7:34:14 PM - Message: The job
>failed. The Job was invoked by User
>COMPAQ\Administrator. The last step to run was step 1
>(Step 1).
>.
>|||In your job that runs these backups, if you're not saving
the job step's output to a file, I'd do that... it may
show what's happening.
Maybe the files can't be deleted due to being locked by
something like a tape backup?
You have Truncate/log on, so in the case a non-logged
command is executed, then I can see why that would cause
your log backup to have problems...
I'd look at each job step output first... Bruce
>--Original Message--
>I tried to trace the History and I fou that I have 2
>problems with this Maintenance Plan :
>Problem A :
>The step that should delete old db files (olderedv then 4
>days ) get the red alert :
>In the History :
>Activity=Delete old DB file backup files
>Status=RED X
>Message=2 file(s) deleted.
>Problem B
>The step that should backup the transaction log event it
>BLUE checked does not succssed !
>In the History :
>Activity=Backup transaction log
>Status=BLUE checked
>Message=Backup can not be performed on this database.
this
>sub task is ignored
>The options that marked in my databases are :
>Truncate log on check point
>Auto create statistic
>Auto update statistic
>.
>sql