I setup a maintenance plan to backup my databases. I ran it and I hit the error below.
The problem is because there are a couple of databases that are having an error -transaction log full due to CHECKPOINT (This is a different story). Hence, I’m not able to backup these databases. If you look at the log closely, you will notice the errors (refer to the screenshot below).
So what I did was to deselect these databases to make the job run successfully.
Alternatively though, you increase the maximum error count to make the job go thru successfully despite hitting errors.
- Right-click on the Backup Task then go to Properties.
2. Increase the number of the “MaximumErrorCount” parameter.
Cheers!
