I have 2 SQL Server 2008 Standard Edition instances that are mirrored. Both instances are running Service Pack 1.
I run Full backups daily and transaction log backups every half hour (through maintenance plans).
My physical DB file is ~22GB. My physical log file has grown to ~41GB.
The log seems to grow the most when running a weekly
INDEX_REORGANIZE. Last week it grew by 15GB. The previous week by 10GB.
My full backups are now ~50GB in size. Shouldn't that be around ~22GB? I feel that the transaction log backups are not properly clearing out space from the log file.
What is the safest way to shrink the transaction log file? I was looking at running
dbcc shrinkfile after a transaction log backup.