I'll start out that I'm a novice and by no means a DBA. Hopefully I explain this correctly and provide information.
We use a product called KANA and just upgraded to a newer release on a new VM. SQL Server 2014
Without trying to say everything in one post (I can answer any questions if more info need) I'll start by stating my main issue.
The log file in the data folder is called Kana_Log. Autogrowth is set to 10 percent and maxsize is unlimited.
We do nightly transaction log backups and backup the database once a week.
I'm pretty sure we have have everything set up just like the older system.
What is happening is the kana_log file never reduces in size. It just keeps getting larger and larger. Recovery model is set to full. I have reduced the size of the log file by using the following commands
ALTER DATABASE [mydatabase] SET RECOVERY SIMPLE
DBCC SHRINKFILE(<log_file_name_Log>)
ALTER DATABASE [mydatabase] SET RECOVERY FULL
The way things worked on the old server was I believe that after a full back up the log file would reduce in size. It does not happen on the new server
I know I probably left a bunch of info out...please ask for more info in order to come to a solution
So bottom line is that the kana_log file just keeps growing and growing and never reduce in size unless I run the above commands.
I may be wrong but isn't the log file supposed to reduce in size after a backup?
Thanks and look forward to any ideas on solving this
https://docs.microsoft.com
HTH