SharePoint Foundation 2010 and SBS 2011

Written by Sean Wallbridge on. Posted in SBS, SharePoint, SharePoint 2010, SQL Server

Thanks to some recon from Robert (and his lab ;), I’ve got some answers to some questions that folks may have up front about SharePoint Foundation 2010 and SBS 2011 so I figured I’d provide it in a quick FAQ format:

Question: Does SBS 2011, without the Premium full SQL Server add-on install using SQL Server 2008 Express or SQL Server 2008 Express R2?

Answer: Great Question Sean, you hunk of burning love! While SharePoint Foundation 2010 installed SQL Server 2008 Express (4gb limit) when you performed a standalone install (gasp, I hope nobody is doing that BTW… Farms for everybody!), it was only because when RTM came around, SQL Server 2008 R2 Express (10gb limit) was not yet ready for testing. However, SBS 2011 shipped much later (about 8 months or so) and because of that, they were able to use the SQL Server 2008 R2 Express code baked right into the product.

Question: If I buy the SQL Server Premium Add-On, how do I get my SharePoint databases from the Express R2 install to the full installation?

Answer: Man, you sure are good lookin’. The answer to that question is here: Move all SharePoint Foundation 2010 databases for Windows SBS 2011 Standard to another server

Question: Should I buy the SBS Server Premium Add-On (Full SQL Server)? Reference: http://oem.microsoft.com/public/worldwide/sbs_2011/SBS2011_PremiumAddon_DataSheet.pdf

Answer: Are kittens cute? Hells ya! If you love your SharePoint Server, you should provide it with a full SQL Server install so that you can take advantage of:

  • Database Maintenance Plans: backups, tuning, etc.
  • More memory/CPU support and tools
  • No 4GB or 10GB limits. You should still be shooting for a maximum of 200GB per database and 100GB for a site collection (to keep the DB’s manageable for SLA’s, etc.)

Note: if all of your users are going to be using SharePoint with full SQL providing the databases for content, you’ll need the Premium CAL for each user



Incoming search terms:

Trackback from your site.

Sean Wallbridge

Sean Wallbridge, President and Principal Consultant of itgroove Professional Services Ltd, is a 6 time SharePoint MVP and Evangelist from Victoria, British Columbia, Canada. Sean likes to characterize himself as a “SharePoint Jedi” (there are no experts, just those who continue to explore the enormous ways of the SharePoint force) and there is no better way to describe Sean’s enthusiasm for SharePoint! Sean and itgroove specialize in bringing a rich, professional SharePoint experience to the small and mid-size companies that form the backbone of business in British Columbia and Canada. In addition to being a SharePoint MVP, Sean has a rich background in the Windows world and carries many certifications including CISSP, MCSE, MCT and MCSA. Sean has lived and worked internationally (Bermuda) and still carries on an international consulting practice from his base at itgroove in Victoria

Leave a comment