{"id":485,"date":"2009-04-06T21:14:00","date_gmt":"2009-04-06T21:14:00","guid":{"rendered":"https:\/\/brainlitter.itgroove.net\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/"},"modified":"2009-04-06T21:14:00","modified_gmt":"2009-04-06T21:14:00","slug":"considerations-for-storing-files-larger-than-50mb-in-sharepoint","status":"publish","type":"post","link":"https:\/\/regroove.ca\/brainlitter\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/","title":{"rendered":"Considerations for storing files larger than 50MB in SharePoint"},"content":{"rendered":"
\n

This question was raised in our little Canadian MVP circle today and I figured if I took the time to reply to the email, I could take the time to post the answer to the blog as well. <\/p>\n

So\u2026 the default maximum file size for uploading to SharePoint is 50MB. This is of course very easily changed in Central Administration. (Note: the maximum file size, regardless of settings\/preferences is 2GB). However, should you? <\/p>\n

\u00a0<\/p>\n

Here’s the question as it was asked\u2026 <\/h1>\n

What’s the ‘infrastructure bods’ view on 50-100Mb files being stored in SharePoint, and I’m talking about 1000’s. I doubt they are going to change or even be accessed that often. <\/p>\n

What are the potential problems with this (backup, restore, SQL, etc)? Or is it all sweetness and light? <\/p>\n

\u00a0<\/p>\n

Here’s my reply to that email\u2026 <\/h1>\n

Providing proper planning, and considerations, 50-100MB files are fine \u2013 1000’s of them could be problematic, so make sure you give the following proper consideration: <\/span><\/p>\n

    \n
  1. \n
    Service Level Agreements for recovery \u2013 what is the SLA for restoring in the event of failure of disaster? <\/span><\/div>\n
      \n
    1. \n
      Using the median of 75MB x 1000 = 75GB \u2013 how long does THAT take to backup (and more importantly restore)?\u00a0 Take that time plus other factors such as: <\/span><\/div>\n
        \n
      1. Noticing the failure <\/span><\/li>\n
      2. Making a decision of what to do about the failure <\/span><\/li>\n
      3. Implementing the recovery solution (restore\/attach\/fix) <\/span><\/li>\n
      4. Testing it works <\/span><\/li>\n
      5. Communicating it is up <\/span><\/li>\n<\/ol>\n<\/li>\n
      6. Assuming 75GB takes 2 hours to restore, plus the other factors, if you had to meet a 3 hour SLA, you may be unable to deliver or find yourself looking at more expensive\/alternative recovery options <\/span><\/li>\n<\/ol>\n<\/li>\n
      7. Never mind the above assumption that there are ZERO (0) versions kept, if you turn on versioning, you are going to have X x<\/em><\/strong> Ymb files <\/span><\/li>\n
      8. Finally, set expectations on the upload itself. Sure, SharePoint and a properly sized\/implemented SQL server can handle this, but what about the network (Internet) connection involved.\u00a0 What load is that placing on everyone else’s experience?\u00a0 Is the link always reliable (GB\/LAN or remote such as Broadband cable).\u00a0 As SharePoint is maturing, so are the technologies that support it (better browsers, better QOS, more bandwidth, more acceptance of web server based applications), so the future is bright but be sure to manage expectations.\u00a0 Consider timeouts, etc. <\/span><\/li>\n<\/ol>\n

        \u00a0<\/p>\n

        This does sound like a job for a dedicated Content DB for sure, at a minimum. <\/span><\/p>\n

        Sean <\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

        This question was raised in our little Canadian MVP circle today and I figured if I took the time to reply to the email, I could take the time to post the answer to the blog as well. So\u2026 the default maximum file size for uploading to SharePoint is 50MB. This is of course very … <\/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":"\nConsiderations for storing files larger than 50MB in SharePoint - 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\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Considerations for storing files larger than 50MB in SharePoint - Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"og:description\" content=\"This question was raised in our little Canadian MVP circle today and I figured if I took the time to reply to the email, I could take the time to post the answer to the blog as well. So\u2026 the default maximum file size for uploading to SharePoint is 50MB. This is of course very …\" \/>\n<meta property=\"og:url\" content=\"http:\/\/regroove.ca\/brainlitter\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/\" \/>\n<meta property=\"og:site_name\" content=\"Brainlitter - Inside the mind of Sean Wallbridge\" \/>\n<meta property=\"article:published_time\" content=\"2009-04-06T21:14: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\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/\",\"url\":\"http:\/\/regroove.ca\/brainlitter\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/\",\"name\":\"Considerations for storing files larger than 50MB in SharePoint - Brainlitter - Inside the mind of Sean Wallbridge\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#website\"},\"datePublished\":\"2009-04-06T21:14:00+00:00\",\"dateModified\":\"2009-04-06T21:14:00+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77\"},\"breadcrumb\":{\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/regroove.ca\/brainlitter\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/regroove.ca\/brainlitter\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Brainlitter\",\"item\":\"https:\/\/regroove.ca\/brainlitter\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Considerations for storing files larger than 50MB in SharePoint\"}]},{\"@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":"Considerations for storing files larger than 50MB in SharePoint - 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\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/","og_locale":"en_US","og_type":"article","og_title":"Considerations for storing files larger than 50MB in SharePoint - Brainlitter - Inside the mind of Sean Wallbridge","og_description":"This question was raised in our little Canadian MVP circle today and I figured if I took the time to reply to the email, I could take the time to post the answer to the blog as well. So\u2026 the default maximum file size for uploading to SharePoint is 50MB. This is of course very …","og_url":"http:\/\/regroove.ca\/brainlitter\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/","og_site_name":"Brainlitter - Inside the mind of Sean Wallbridge","article_published_time":"2009-04-06T21:14: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\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/","url":"http:\/\/regroove.ca\/brainlitter\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/","name":"Considerations for storing files larger than 50MB in SharePoint - Brainlitter - Inside the mind of Sean Wallbridge","isPartOf":{"@id":"https:\/\/regroove.ca\/brainlitter\/#website"},"datePublished":"2009-04-06T21:14:00+00:00","dateModified":"2009-04-06T21:14:00+00:00","author":{"@id":"https:\/\/regroove.ca\/brainlitter\/#\/schema\/person\/74e1c0def190f181c1394c2b6d883e77"},"breadcrumb":{"@id":"http:\/\/regroove.ca\/brainlitter\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/regroove.ca\/brainlitter\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/regroove.ca\/brainlitter\/2009\/04\/06\/considerations-for-storing-files-larger-than-50mb-in-sharepoint\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Brainlitter","item":"https:\/\/regroove.ca\/brainlitter\/"},{"@type":"ListItem","position":2,"name":"Considerations for storing files larger than 50MB in SharePoint"}]},{"@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\/485"}],"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=485"}],"version-history":[{"count":0,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/posts\/485\/revisions"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/media?parent=485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/categories?post=485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/brainlitter\/wp-json\/wp\/v2\/tags?post=485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}