Good Day, Maintenance job for Transaction log is failing due to below error, Executed as user:Alex\ti_sam. Microsoft (R) SQL Server Execute Package Utility.. Started: 10:30:01 AM Progress: 2010-10-29 10:30:05.97 DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:30:01 AM Finished: 10:33:02 AM Elapsed: 3.047 seconds. The package execution failed. The step failed. Can you please advise Rgds,
When you say maintenance job, what tasks are you performing in the maintenance job? Backups? Is it possible that someone has taken a backup outside of the maintenance plan, and possibly broken the log chain?