emile.milne (10/8/2012)
Hi I have a tempdb that is 45gb in size. When I go to shrink db it says there is 99% free.When I go to shrink file,( I have multiple file groups) each file reports less than 4% free. How can this be if the db is 99% empty. 3 of the files have autogrown by 10% today.
Any ideas why the mismatch in figures.
Depending on your version of SQL Server, this could be an issue of inaccurate values being reported.
Details can be found at: http://blogs.msdn.com/b/ialonso/archive/2012/10/08/inaccurate-values-for-currently-allocated-space-and-available-free-space-in-the-shrink-file-dialog-for-tempdb-only.aspx
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding