Solved

Transaction Log Fails to Shrink

Posted on 2009-04-13
2
513 Views
Last Modified: 2013-11-10
My buddy created a Shrink Transaction Log task for a Tran Log that grows to roughy 1.5 GB every night.  (A sizable job that must be logged runs every evening accounts for this increase.)  He'd like to reduce the log after the job runs, but his Shrink Database Task fails to shrink the log file at all.  The Maintenance Job Log file shows that the job runs successfully, but with no results.  What may be preventing the Tran Log from shrinking?
0
Comment
Question by:jdana
2 Comments
 
LVL 22

Accepted Solution

by:
dportas earned 250 total points
ID: 24130967
Log will only remove unused space from the log.

Shrinking should never be scheduled to run on a regular basis. It should be run in exceptional circumstances only. Continual shrinking and growing is a huge waste of resources, causes unwanted fragmentation and in practice it saves you no disk space at all. Don't schedule the shrink task. Set the log to the size it needs to be and then leave it alone.
0
 

Author Closing Comment

by:jdana
ID: 31569563
Sounds reasonable.  Thanks for the advice.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Quer 4 21
SQL R 21 25
query optimization 6 14
reccommendations for a free msft sql query manager? 4 27
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question