Unable to shrink SQL log file
Posted on 2009-05-07
Hello - we are running SQL Server 2005 on a 2003 Windows Server, and have a miantenance script in place to maintain the database. Part of the script issues a DB shrink command:
DBCC SHRINKDATABASE(N'LaCo_AX_Test', 10, TRUNCATEONLY)]
"LaCo_AX_Test" is the name of our database. The log file is at 3.7tg, and has stayed that size for the past few shrink executions. What are reasons that a log file would not shrink down in size?