• most of my full log issues have been because of replication. for some reason it didn't truncate the log. so the solution is to reinitialize the publication and it almost always works. once or twice we had to delete and rebuild the publication.

    on db's where we don't run log backups, we do backup log with no_log on a regular schedule and keep the db's in simple recovery mode