• If your recovery model is set to FULL and you are not doing T-log backups your transaction log will continue to grow, until eventually it will become larger than the database itself.

    By all means, if you are only doing database backups set the recovery model to SIMPLE.

    The probability of survival is inversely proportional to the angle of arrival.