{"id":461,"date":"2009-03-08T13:47:00","date_gmt":"2009-03-08T13:47:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/"},"modified":"2009-03-08T13:47:00","modified_gmt":"2009-03-08T13:47:00","slug":"default-basic-databases-used-by-sharepoint-versions","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/","title":{"rendered":"Default (Basic) Databases used by SharePoint Versions"},"content":{"rendered":"<div class=\"ExternalClass3AC471009A004AE984E7EC2587BD4C0E\">\n<div><font size=\"2\">First off, I never install SharePoint (WSS or MOSS) with the default configuration. This would leave me without the ability to grow a farm (and if we implement SharePoint right for an organization, its popularity and use with grow and if it makes us profitable, we&#8217;ll need to grow it &#8211; as my old boss used to say it is a &#8216;Happy Problem&#8217;.<\/font><\/div>\n<div><font size=\"2\"><\/font>\u00a0<\/div>\n<div><font size=\"2\">So, here&#8217;s what you need to know about the default databases for WSS 3.0 and MOSS 2007 &#8211; noting especially that using the FREE SQL with WSS 3.0 isn&#8217;t a bad idea, but using the FREE SQL with MOSS 2007 is&#8230;<\/font><\/div>\n<ul>\n<li>\n<p class=\"MsoNormal\" style=\"margin:0in\"><span lang=\"EN-CA\" style=\"color:black;font-family:'Verdana','sans-serif'\"><font size=\"2\">When you install WSSv3 using the default (Basic) installation it installs all the stuff on a single server and uses &#8220;embedded SQL Server 2005 Express&#8221; as the database.\u00a0 This special edition is called &#8220;Windows Internal Database&#8221; or &#8220;WID&#8221; and has an unlimited capacity (it is also the same database used by WSUS)<\/font><\/span><\/p>\n<\/li>\n<li><span lang=\"EN-CA\" style=\"color:black;font-family:'Verdana','sans-serif'\">\n<p class=\"MsoNormal\" style=\"margin:0in 0in 0pt;vertical-align:top\"><span lang=\"EN-CA\" style=\"color:black;font-family:'Verdana','sans-serif'\"><font size=\"2\">When you install\u00a0MOSS 2007\u00a0using the default (Basic) installation it installs all the stuff on a single server and uses &#8220;embedded SQL Server 2005 Express&#8221; as the database.\u00a0 However, it is does not use WID &#8211; it has the standard 4GB SQL limit (thus you won&#8217;t go far using this and changing can be a punishing or at least time consuming effort)<\/font><\/span><\/p>\n<p><\/span><\/li>\n<\/ul>\n<p><span lang=\"EN-CA\" style=\"color:black;font-family:'Verdana','sans-serif'\"><\/p>\n<p class=\"MsoNormal\" style=\"margin:0in 0in 0pt;vertical-align:top\"><span lang=\"EN-CA\" style=\"color:black;font-family:'Verdana','sans-serif'\"><font size=\"2\"><\/font><\/span>\u00a0<\/p>\n<p class=\"MsoNormal\" style=\"margin:0in 0in 0pt;vertical-align:top\"><span lang=\"EN-CA\" style=\"color:black;font-family:'Verdana','sans-serif'\"><font size=\"2\">Note, if you were to upgrade WSS 3.0 to MOSS 2007, you would (of course) then have a real Microsoft SQL Server (2005 or 2008) on hand.\u00a0 However, only new databases would end up in SQL Server, while your existing Farm Confirmation and Content Databases would stay in the WID until you move them (you *can* move them of course).<\/font><\/span><\/p>\n<p><\/span><\/div>\n","protected":false},"excerpt":{"rendered":"<p>First off, I never install SharePoint (WSS or MOSS) with the default configuration. This would leave me without the ability to grow a farm (and if we implement SharePoint right for an organization, its popularity and use with grow and if it makes us profitable, we&#8217;ll need to grow it &#8211; as my old boss &hellip; <a href=\"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/\"><\/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":[337,14,428,339],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Default (Basic) Databases used by SharePoint Versions - 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=\"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Default (Basic) Databases used by SharePoint Versions - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"First off, I never install SharePoint (WSS or MOSS) with the default configuration. This would leave me without the ability to grow a farm (and if we implement SharePoint right for an organization, its popularity and use with grow and if it makes us profitable, we&#8217;ll need to grow it &#8211; as my old boss &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2009-03-08T13:47: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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/\",\"url\":\"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/\",\"name\":\"Default (Basic) Databases used by SharePoint Versions - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2009-03-08T13:47:00+00:00\",\"dateModified\":\"2009-03-08T13:47:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Default (Basic) Databases used by SharePoint Versions\"}]},{\"@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":"Default (Basic) Databases used by SharePoint Versions - 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":"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/","og_locale":"en_US","og_type":"article","og_title":"Default (Basic) Databases used by SharePoint Versions - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"First off, I never install SharePoint (WSS or MOSS) with the default configuration. This would leave me without the ability to grow a farm (and if we implement SharePoint right for an organization, its popularity and use with grow and if it makes us profitable, we&#8217;ll need to grow it &#8211; as my old boss &hellip;","og_url":"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2009-03-08T13:47:00+00:00","author":"Sean Wallbridge","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Sean Wallbridge","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/","url":"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/","name":"Default (Basic) Databases used by SharePoint Versions - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2009-03-08T13:47:00+00:00","dateModified":"2009-03-08T13:47:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/brainlitter\/2009\/03\/08\/default-basic-databases-used-by-sharepoint-versions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"Default (Basic) Databases used by SharePoint Versions"}]},{"@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\/461"}],"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=461"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/461\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}