Sunday, February 26, 2012

Free space not used.

Executing
exec sp_spaceused <my_table>
I notice this:
reserved --> 4483504 KB
data --> 2536720 KB
unused --> 1896984 KB
I have to "free" that space and I tried the following:
1) DBCC DBREINDEX (<my_table> )
2) DBCC SHRINKDATABASE ('<my_db>')
but the didn't work.
How can I do to "give" that space to Os?
Any help much appreciated.
Best regards.
Fabri
("Sono pi di 30 punti...ma come se fossere 8 o 9...")"DBCC SHRINKFILE"
http://msdn.microsoft.com/library/d...
b51.asp
"Shrinking the Transaction Log"
http://msdn.microsoft.com/library/d...r />
_1uzr.asp
"INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE"
http://support.microsoft.com/kb/272318/EN-US/
Cristian Lefter, SQL Server MVP
"Fabri" <no@.sp.am> wrote in message news:d84956$p4o$1@.news.ngi.it...
> Executing
> exec sp_spaceused <my_table>
> I notice this:
> reserved --> 4483504 KB
> data --> 2536720 KB
> unused --> 1896984 KB
> I have to "free" that space and I tried the following:
> 1) DBCC DBREINDEX (<my_table> )
> 2) DBCC SHRINKDATABASE ('<my_db>')
> but the didn't work.
> How can I do to "give" that space to Os?
> Any help much appreciated.
> Best regards.
> --
> Fabri
> ("Sono pi di 30 punti...ma come se fossere 8 o 9...")

No comments:

Post a Comment