Backup Transaction Log job failing

Question

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

bp SSCarpal Tunnel Points: 4656 More actions · Answer 1

Here are some kbs that related to maintenance plans:

HTH

Billy

zach_john SSCertifiable Points: 5922 More actions · Answer 2

Under database options check to see if the truncate log on check point isn't set.

Do you any nonlogged updates? A DTS package moving a table or rebuilding a table?

John Zacharkan

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 3

Check maintenance plan history to see any errors reported?

sbendayan SSCommitted Points: 1791 More actions · Answer 4

Thanks for the replies.....it was the Truncate log on chkpt setting....it needs to be set to off.