{"id":711,"date":"2011-05-11T22:19:00","date_gmt":"2011-05-11T22:19:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/"},"modified":"2011-05-11T22:19:00","modified_gmt":"2011-05-11T22:19:00","slug":"sharepoint-foundation-2010-and-sbs-2011","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/","title":{"rendered":"SharePoint Foundation 2010 and SBS 2011"},"content":{"rendered":"<div class=\"ExternalClassB74D187D003C4D3BB59F93110156679E\">\n<p><span style=\"font-family:Times New Roman;font-size:12pt\"><em>Thanks to some recon from Robert (and his lab ;), I&#8217;ve got some answers to some questions that folks may have up front about SharePoint Foundation 2010 and SBS 2011 so I figured I&#8217;d provide it in a quick FAQ format: <\/em><\/span><\/p>\n<\/p>\n<p><span style=\"font-family:Arial;font-size:12pt\"><span style=\"color:#c0504d\"><strong>Question<\/strong>: Does SBS 2011, without the Premium full SQL Server add-on install using SQL Server 2008 Express or SQL Server 2008 Express R2? <\/span><\/span><\/p>\n<\/p>\n<p><span style=\"font-family:Arial;font-size:12pt\">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\u2026 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.<\/span><\/p>\n<\/p>\n<p><span style=\"font-family:Arial;font-size:12pt\"><span style=\"color:#c0504d\"><strong>Question<\/strong>: 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? <\/span><\/span><\/p>\n<\/p>\n<p><span style=\"font-family:Arial\"><span style=\"font-size:12pt\">Answer: Man, you sure are good lookin&#8217;. The answer to that question is here: <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/gg616007.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">Move all SharePoint Foundation 2010 databases for Windows SBS 2011 Standard to another server<\/a><\/span><span style=\"color:black;font-size:15pt\"><strong><\/strong><\/span><span style=\"font-size:12pt\"><\/span><\/span><\/p>\n<\/p>\n<p><span style=\"font-family:Arial;font-size:12pt\"><span style=\"color:#c0504d\"><strong>Question<\/strong>: Should I buy the SBS Server Premium Add-On (Full SQL Server)? Reference: <a href=\"http:\/\/oem.microsoft.com\/public\/worldwide\/sbs_2011\/SBS2011_PremiumAddon_DataSheet.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/oem.microsoft.com\/public\/worldwide\/sbs_2011\/SBS2011_PremiumAddon_DataSheet.pdf<\/a><\/span><\/span><\/p>\n<\/p>\n<p><span style=\"font-family:Arial;font-size:12pt\">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:<\/span><\/p>\n<ul>\n<li><span style=\"font-family:Arial\">Database Maintenance Plans: backups, tuning, etc.<\/span><\/li>\n<li><span style=\"font-family:Arial\">More memory\/CPU support and tools<\/span><\/li>\n<li><span style=\"font-family:Arial\">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&#8217;s manageable for SLA&#8217;s, etc.)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family:Arial\"><em><strong>Note<\/strong>: if all of your users are going to be using SharePoint with full SQL providing the databases for content, you&#8217;ll need the Premium CAL for each user<\/em><\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Thanks to some recon from Robert (and his lab ;), I&#8217;ve got some answers to some questions that folks may have up front about SharePoint Foundation 2010 and SBS 2011 so I figured I&#8217;d provide it in a quick FAQ format: Question: Does SBS 2011, without the Premium full SQL Server add-on install using SQL &hellip; <a href=\"https:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/\"><\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[436,14,334,428],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SharePoint Foundation 2010 and SBS 2011 - Brainlitter - Inside the mind of Sean Wallbridge<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SharePoint Foundation 2010 and SBS 2011 - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"Thanks to some recon from Robert (and his lab ;), I&#8217;ve got some answers to some questions that folks may have up front about SharePoint Foundation 2010 and SBS 2011 so I figured I&#8217;d provide it in a quick FAQ format: Question: Does SBS 2011, without the Premium full SQL Server add-on install using SQL &hellip;\" \/>\n<meta property=\"og:url\" content=\"http:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2011-05-11T22:19:00+00:00\" \/>\n<meta name=\"author\" content=\"Sean Wallbridge\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sean Wallbridge\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/\",\"url\":\"http:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/\",\"name\":\"SharePoint Foundation 2010 and SBS 2011 - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2011-05-11T22:19:00+00:00\",\"dateModified\":\"2011-05-11T22:19:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SharePoint Foundation 2010 and SBS 2011\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/\",\"name\":\"Brainlitter - Inside the mind of Sean Wallbridge\",\"description\":\"Dad. Husband. Drummer. Learner of Things.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\",\"name\":\"Sean Wallbridge\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g\",\"caption\":\"Sean Wallbridge\"},\"url\":\"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SharePoint Foundation 2010 and SBS 2011 - Brainlitter - Inside the mind of Sean Wallbridge","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/","og_locale":"en_US","og_type":"article","og_title":"SharePoint Foundation 2010 and SBS 2011 - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"Thanks to some recon from Robert (and his lab ;), I&#8217;ve got some answers to some questions that folks may have up front about SharePoint Foundation 2010 and SBS 2011 so I figured I&#8217;d provide it in a quick FAQ format: Question: Does SBS 2011, without the Premium full SQL Server add-on install using SQL &hellip;","og_url":"http:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2011-05-11T22:19:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/","url":"http:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/","name":"SharePoint Foundation 2010 and SBS 2011 - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2011-05-11T22:19:00+00:00","dateModified":"2011-05-11T22:19:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"http:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/regroove.ca\/brainlitter\/2011\/05\/11\/sharepoint-foundation-2010-and-sbs-2011\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"SharePoint Foundation 2010 and SBS 2011"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/brainlitter\/#website","url":"https:\/\/regroove.ca\/brainlitter\/","name":"Brainlitter - Inside the mind of Sean Wallbridge","description":"Dad. Husband. Drummer. Learner of Things.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/brainlitter\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77","name":"Sean Wallbridge","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adf8cea6291c39d166616f2148d919a6?s=96&d=mm&r=g","caption":"Sean Wallbridge"},"url":"https:\/\/regroove.ca\/brainlitter\/author\/swallbridge\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/711"}],"collection":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/comments?post=711"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/711\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}