Update:

-I reclaimed the log space back to just over 8Gb, very acceptable.

-The snapshot replication I had set up was removed. Thanks for having me script it first, I now have...

:-D:-D:-D:-D:-D:-D

You are an angel, thank you so much!

See screenshots. Doing a log backup now!

It shows my snapshot, and at the moment the transactional dummy one from your instructions.

Ok, I followed you instructions but am sad to say nothing changed. I have provided screen shots of each step of the way. I even did a tlog spin off...

THIS is why I subscribe to this site. Experience, professionalism, and a modest amount of hand-holding when it's called for. I appreciate your advice immensely, and I will attempt your...

OK I am not sure how you arrived at this conclusion, and I am quite sure that I did not set up and partial trans replication, so let me give...

Sorry, I did omit that. Just snapshot replication, once a day.

Transaction information for database 'AX30_SP6_LIVE'.

Replicated Transaction Information:

Oldest distributed LSN : (0:0:0)

...

I forgot to mention that I have this db as a production ERP db, and I have it replicated (partially) to another server so that we can report on it...

SSRS is the way to go. I have over 200 custom reports I use in various ways. Most are on demand by the user, they click on the web link...