29Apr/090
When Microsoft SQL Transaction Log Backups Fail
So this either shows how much of a Microsoft SQL noob I am or something but I had been having problems getting transaction log backups to run successfully. This was happening with two maintenance plans at two different companies and I couldn't figure out why. Today I asked the vendor for one of the databases if they knew what the problem was and he had the golden answer. He told me that the database recovery mode was set to basic and that this would cause it to fail and he suggested setting it to bulk-logged. So I made the change to the database, and ran the transaction log backup job and it worked! So, if you are having transaction log backup problems check the database recovery model option, this could be your problem.
