Usually a tran log maintenance plan failure is because one of the
databases are using simple recovery model and you cannot backup a tran log
of a db using simple recovery model. Go into the job step that executes
the maintenance plan and copy that command into query analyzer. Take a
look at the output. Any errors will show up there.

Thanks,
Lisa Greetham
Database Administrator, Corporate Internet Group
Bank One




"Chris Kempster" <[Email Address Removed] 10:15 PM
Please respond to
[Email Address Removed] Discussion" <[Email Address Removed] Re: RE: Maintenance jobs are failing






another thing to try, did you schedule/create the maintenance plan from
your
client or on the server? try at the server and re-run the job.

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.

MS Sql Server LazyDBA home page