question

pits avatar image
pits asked

logerror DTSER

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,
error-trap
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Kev Riley avatar image
Kev Riley answered
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?
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.