Thank you for the quick response.
I read the article and it says "If (once the log backups have been setup and scheduled based on the database's RPO) the log is growing larger than is acceptable, then the log backup frequency can be increased in order to keep the size down."
I'm confused ... how is it supposed to do that? In my situation, I have a transaction log file that is 1.5gb and it has gone through a few days of transaction log backup at 12:00pm. However, the size is still 1.5gb.
I executed the following
SELECT * FROM sysfiles;
GO
This is actually the concern. My log file is larger than my data file. That was the reason I started researching on Transaction Logs. For that matter, should I even be concern with my log file larger than my data file?
In addition, I have a "Work in Progress to do" list from the former DBA to shrink log files on databases where the log file is larger than the data file.