Here’s a walk through of the installation of SharePoint Foundation 2010 Service Pack 1 on a stand alone server not connected to a domain with a default install of SharePoint Foundation 2010. I'll look at doing something for SBS 2011 Standard soon.
The first thing you’ll need to do is download the Service Pack 1 file which can be found at:
Right mouse click on the file and ‘Run as administrator’
Next, accept the license terms at bottom.
The Service Pack will now commence installation.
You will receive a message indicating the process is complete. However, all that has happened that the binary files have been updated. You need to now apply the update to SharePoint Foundation 2010 manually. This is because now you must manually run PSCONFIG after installing SharePoint 2010 patches on ANY server that SharePoint Foundation 2010 is installed on.
To check to see whether the Service Pack has been installed correctly, firstly run the SharePoint Central Administration. Select System Settings and then Manage servers in this farm.
Note the Configuration database version. Unless it is 14.0.6029.1000 Service Pack 1 has not yet been applied to the SharePoint farm.
To apply the downloaded update to the SharePoint farm run a command prompt as an administrator.
Change to directory c:\program files\common files\microsoft shared\web server extensions\14\bin and execute the following command:
PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures
You should see the process complete 6 stages in total like shown above.
If you now check the version of the configuration database in Central Administration as shown previously it should be 14.0.6029.1000.
One of the additional features that Service Pack 1 provides is the ability to view the storage usage on a site. To see this go into your site and select Site Settings. You should now notice a new option under Site Collection Administration called Storage Metrics.
As you can see from the above screen shot, this now gives you a break down of exactly where space is being used in your site.
If nothing else this is a great reason to install SharePoint Foundation service Pack 1.