View Complete Post
Here is the story so far. I have a Sharepoint 2007 installation using SQL 2008. I turned on versioning on a heavily use library which caused the versions table to explode in size (the DB was 100gb before afterwards 580gb). I pruned
out the extaneous versions but the table is not shrinking. I have done several queries to find the size of the data being stored in the elements and it comes to around 22gb (which sounds right) but when I do a properties on the table it still says the
table is over 400gb. Now here is the strange thing I took a backup (I didn't want to monkey around with production data) and restored it to a test environment. In the test environment the space is gradually being reclaimed and over the course of
a week the table has returned to a normal size.
My question is this, is it possible for the application (in this case Sharepoint) to be locking the database in a way that it cannot reclaim that space. Is there a command (online preferred but offline if needs be) I can run to reclaim whitespace?
Like others, I've recently had repeated updates of .Net Framework 4 (KB2446708) which where successfully installed . Before finding this site, I Googled the issue and it was suggested that I download & run the MS dotnet_cleaup_tool which
I did. It was also suggested to download & install the full version of .Net 4 (filename: dotNetFx49_Full_x86_x64 which I also did. They both seemsed to work.
Unfortunately, when I ran the cleanup tool I mistakenly deleted ALL versions of .Net Framework. I did do the instal of the "full" V4 application.
Questions: How do I reinstall the prior versions? Do I need them all back to V1? Is there a specific order they should be installed? Should I perform update requests after each version has been installed?
TIA for your help.