RE: Maintenance Plan for Transaction Logs is failing

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 09/21/04 

Date: Tue, 21 Sep 2004 09:49:04 -0700

Hi

Is the database is full recovery mode (not simple or bulk logged)?

Regards
Mike

"Sean" wrote:

> Good Morning All,
>
> I cannot figure out why the maintenance plan for
> transaction log backups is failing. The plan for the DB
> works fine. Below is the error message from the event log
> and below that is Step 1.
>
> TIA
> Sean
>
> SQL Server Scheduled Job 'Transaction Log Backup Job for
> DB Maintenance Plan 'DB Maintenance Plan1''
> (0xCF8E57D6205B3A4C898152532CCBB6DA) - Status: Failed -
> Invoked on: 2004-09-20 22:00:00 - Message: The job
> failed. The Job was invoked by Schedule 12 (Schedule 1).
> The last step to run was step 1 (Step 1).
>
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID E2703225-E616-
> 4636-B9B3-1EE3A4767763 -Rpt "d:\Program Files\Microsoft
> SQL Server\MSSQL\LOG\DB Maintenance Plan16.txt" -DelTxtRpt
> 4WEEKS -WriteHistory -VrfyBackup -BkUpMedia DISK -
> BkUpLog "d:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP" -DelBkUps 1DAYS -BkExt "TRN"'
>
>