June 1, 2010 at 6:08 am
i shrink a datafile using DBCC command ( That also had TruncateONLY Option) and I also Reorganize all the indexes then after.
But still i t doesn't releases unused space.
Can anyone tell me why it happens so????
June 1, 2010 at 6:30 am
Check the Utilization% of the file.
And in-case if there is some space you can check if there is any active or sleeping SPID on the db if yes then either wait for it to get resolved or kill it....
~RD
June 1, 2010 at 2:10 pm
janki_2886 (6/1/2010)
i shrink a datafile using DBCC command ( That also had TruncateONLY Option) and I also Reorganize all the indexes then after.But still i t doesn't releases unused space.
Can anyone tell me why it happens so????
This was more of a problem in older versions of SQL Server, but I ran across it in SQL Server 2005 a time or two as well. Check out this link. Maybe it will help.
http://johnnynine.com/blog/HowToImmediatelyShrinkSqlServerLogFilesLDFFiles.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply