SQL Server Performance Forum – Threads Archive
Keep t-log size down
On SQL2000 we have several DB of about 7 GB and the t-logs are about the same size. How can we keep the log size down to conserve disk space? What we are doing now doesn’t seem to make much of a difference in the size. We are backing up every 2 hours, shrinking as part of a mainteneance plan, and using the following script once per week. USE TAPPEAPPGO
DUMP TRANSACTION TAPPEAPP WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE(TAPPEAPP_LOG,TRUNCATEONLY)
GO All actions report success but the size of the file doesn’t change much. Is there a way to set a size limit on the t-log? If so, how would we know what size to specify, i.e. would it contain all of the transactions we want to keep. Thanks!
There is no way, and you should not limitate, log file.
There size razon is because you have model recovery = full.
If you change to single, log will reduce a lot, but it is not recomended with kind of backup allready in use.
Luis Martin
Moderator
SQL-Server-Performance.com
]]>