I use the maintenance plan of SQL Server, but it does not work well.
Transaction log truncation flow in the maintenance plan:
① Database consistency check task ↓ ② Database compression task ↓ ③ Database backup task (Transaction log backup) ↓ ④ Truncate transaction log area (execute T-SQL)
If run the maintenance plan manually in the manual server, it will successfully terminate the transaction log area and reduce the size.
The size is not reduced while the transaction log area is truncated, even though the schedule is successfully terminated.
Is there any problem with the execution of the maintenance plan?
USE [XXX system _SQL] GO DBCC SHRINKFILE (XXX system _SQL_log, TRUNCATEONLY) GO