I have a database where the transaction log keeps filling up. I'm not sure this particular database really needs a transaction log. So I'm thinking of either deleting it or having it roll off automatically after two weeks.
How do I delete a transaction log and stop the logging? Also, is there a way of making a transaction roll off (drop prior logs) after two weeks automatically?