Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

reclaiming disk space

  Asked By: Darren    Date: Aug 12    Category: Sharepoint    Views: 1768

Running SPS-2 on SBS 2003 and deleted a site via sharepoint central

It's been awhile since I've messed with sharepoint and I know the data is
stored in SQL, but I thought central administration would delete it all when
I went to delete the site and even warns that it will..

I am still showing the disk space is taken by some 50 gb or so and would
like to reclaim that space, can anyone help me out please?



7 Answers Found

Answer #1    Answered By: Ian Powell     Answered On: Aug 12

A couple things:

1) What is SPS-2? SBS 2003 runs WSSv2 and can run WSSv3 in a
side-by-side install, but I don't think SPS2003 or MOSS is supported.

2) Yes, the content is store in SQL Server, and SQL does not
auto-shrink its databases. The space  continues to be allocated for SQL,
and is "free" as far as SQL is concerned, but to reclaim it on disk
you'll need to do a reindex on the database which will shrink the
on-disk allocation for the database.

Answer #2    Answered By: Osvaldo Winters     Answered On: Aug 12

Sps2= sharepoint services 2. wssv2 in other words, thanks for correcting me.
So are you saying the space  is there (available physically) and the server
just doesn't see it?

Not sure how to re-index, is that done in sql enterprise manager someplace?

Answer #3    Answered By: Kylie Gill     Answered On: Aug 12

The way SQL Server works is it allocates file system space  into a
SQL-specific data file which is managed inside SQL itself and that file
grows as necessary to contain all of the SQL-stored content. Once you
delete items in SQL, it does not change the size of the data file on
disk - this is for performance reasons (resizing is slow and resource
intensive). SQL does however know how much content it has and how much
disk space it has allocated, so it sees the space as "free" for SQL
purposes, so it won't grow the data file on disk  again until it is all
used up with SQL content again.

Reindexing is done via a SQL statement - see

Answer #4    Answered By: Brianna Olson     Answered On: Aug 12

So the space  has been reclaimed and is there to reuse as we see fit, it's
just showing as used on the c-drive since sql disk  space allocation is

Kind of like my 350 lb brother who quit eating doughnuts last year, he's
down to 250, but still wears the same clothes.

Answer #5    Answered By: Allyson Burgess     Answered On: Aug 12

Yep, you've got it................

Answer #6    Answered By: Anila Bhuva     Answered On: Aug 12

Yup, you got it. SQL will use the space  as you upload new documents and
create new content.

Answer #7    Answered By: Elaine Mack     Answered On: Aug 12

Unless you are running  out of drive space, I wouldn't recommend
shrinking your SQL databases. They're just going to get larger again as
you add more content to SharePoint. If you shrink them now, and force
them to grow you increase the chances that the MDF files will be
fragmented on the file system, which will result in slower performance.

Didn't find what you were looking for? Find more on reclaiming disk space Or get search suggestion and latest updates.