Upgrading your SharePoint databases
If you look at the “Review database status” page under “Upgrade and Migration” in SharePoint 2010 Central Administration, you may see a message in the status column that says something like “Database in compatibility range and an upgrade is recommended”. To do this you need to run the PowerShell command “Upgrade-SPContentDatabase but to do this you need to get the identity of each database you want to upgrade and run this command for each one. I have numerous clients that have more than one content db, and you may also want to upgrade the Central Admin databases too, so I have written a PowerShell function that takes in the Web Application and upgrades all databases attached to it:
Function UpgradeDatabases($webApp)
{
$web = Get-SPWebApplication -Identity $webApp
foreach($contentDB in $web.ContentDatabases)
{
Upgrade-SPContentDatabase -id $contentDB
}
}
A pretty straight forward function. Below is the ps1 file.
Download UpgradeDatabases file
Disclaimer:
Please read the disclaimer if you plan on using anything from this article.
SharePoint 2010–Applying updates
In the previous versions of SharePoint, when you applied an cumulative update or service pack to the server version, you had to install the SharePoint services update then the server update. In 2010, Microsoft have done away with that practice and now if you have SharePoint server and not SharePoint Foundation running, you just need to apply the server CU or SP and not both the server and foundation versions as Microsoft are now rolling the foundation updates into the server updates.
If you want more information on the updates for SharePoint 2010 (Foundation and Server), I suggest you visit the Updates for SharePoint 2010 Products page on the TechNet site. All the information, and links to download the updates are there.
about me
I am a C#, Silverlight, K2 workflow and Sharepoint Consultant, living and working in Johannesburg, South Africa. I have a passion for teaching people anything I can in order to spread the knowledge and skills I have. You can follow me on twitter at @MrThirsty.