DB free space

Hello,
I can see a lot of free space in databases some have 30% free, tempdb has 99% of free space, but "shrink " would not release that space to the OS. Is there other way to return database free space to the Windows?
Thanks
Ilya
Before you go ahead and free the space - consider why you're doing it. Are
you doing it for any particular reason or is it just to shrink the database.
The odds are that the database will just grow again (depending on your
workload, data etc) so the shrink you perform is wasted effort. If a
database continually grows after you shrink it, that means the database
needs the extra space for regular working - so don't do the shrink.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"iLya" <anonymous@.discussions.microsoft.com> wrote in message
news:738A5282-1FEC-4D78-AFAD-5C29B08A60BC@.microsoft.com...
> Hello,
> I can see a lot of free space in databases some have 30% free, tempdb has
99% of free space, but "shrink " would not release that space to the OS. Is
there other way to return database free space to the Windows?
> Thanks
> Ilya
|||We made copy of a few very big tables to fix some problems, then deleted them. When we created those tables size of db has grown to 63GB from 52GB. After we deleted temp tables size did not change it's still 63GB. We need to shrink.
Thanks
Ilya