• ok sorry for my misunderstanding but I thought that is why you do Log backups to commit the data to the DB and clear the transaction data from the Log file to prevent excessive growth.

    I understand your comment on the log transaction being open and makes me wonder about the application that does these transactions. Maybe I need to put into the routine to also restart this application daily to kill the connection.

    So bottom line you think the db itself is ok and I just need to figure out why the heck we are getting this continued log growth. Any suggestions would be great and I can move to a different topic if required.