May 23, 2012 at 9:32 am
I have removed a large number of indexes and now my .ldf file has 50% free space. I would like to shrink it to 10% free space. How can I shrink these files. I have tried this
USE [DW_PolicyDatamart]
GO
DBCC SHRINKFILE (N'DW_PolicyDatamart_Indices' , 0, TRUNCATEONLY)
GO
which doesn't work.
Ideas?
Thanks
Kevin
May 23, 2012 at 9:38 am
The log works with a series of mini-segments inside. You can't shrink past an active segment, so if it's at the end of the file, you can't shrink.
There's a forcibly shrink script on this site that will help. It basically runs transactions to get the log to wrap back to the beginning and then shrinks.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply