We make maintenance plan to shrink log files.
1. Backup Transaction logs
2. Run Execute T-SQL Statement Task
USE [yourDB]
DBCC SHRINKFILE (N'yourDB_log' )
>Here is the numbers:
>
>The database is taking 26851.05 for its log. This is 26 GB.
>
>So, there is no maintenance on that one. It just keeps increasing. So, we might have reached a limit here or something that SQL Server cannot execute this operation without applying a lock. So, we would have to look at how to lower that log file and keep it to a maximum. How are you doing it on your end?
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
