SQL LDF not smaller after truncation
Challenge
Cause
One must manually shrink or configure “Auto Shrink” to make the LDF itself physically smaller.
Solution
1. Open SQL Management Studio and connect to the SQL instance where the database in question is located.
2. Right-Click on the database and goto Tasks>Shrink>Files
3. Switch to Log under File type...
This will show you the current allocated space and the available free space.
In this example the LDF is 34.88 MB and internally it has 89% free space.
The database in this example is set for simple recovery model which keeps the log size low, when a SQL database is configured for full recovery model the LDF could be considerably larger.
The release unused space option will shrink the LDF file down to whatever you have designated as the minimum size in the database properties:
Information regarding the Auto Shrink option can be found in the this MS article http://support.microsoft.com/kb/315512.
Couldn't find what you were looking for?
Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!
Spelling error in text
Do you have an issue or need post-sales technical assistance?
*if you need help choosing the right product, please select "Sales" chat
Do you need guidance on the website, upgrade hints or help with your licenses/accounts?
Questions regarding your Veeam contract renewal? Contact us and learn how you can maximize your savings
Do you need additional license, pricing details, product information or have any other sales-related question?
Would you like to become our partner or do you need assistance as our existing partner?
We apologize, but this chat is not available at the moment
We apologize, but this chat is not available at the moment
We apologize, but this chat is not available at the moment
We apologize, but this chat is not available at the moment
Veeam representative will get back to you shortly.
