none
Upload documents in document library RRS feed

  • Question

  • Hi,

    I need to upload huge(80GB) set of document folders into sharepoint document library.

    Kindly let me know what are all the necessary action (for eg. application & databse server free space) i need to take care before i start implementing it.

    Kindly help me.

    Regards,
    Hari

    • Moved by Mike Walsh FIN Monday, June 29, 2009 2:37 PM admin q (From:SharePoint - Enterprise Content Management)
    • Changed type Mike Walsh FIN Monday, June 29, 2009 3:51 PM always use the question type so people get credit for their replies to you
    • Changed type Mike Walsh FIN Monday, June 29, 2009 3:51 PM always use the question type so people get credit for their replies to you
    • Changed type Mike Walsh FIN Monday, June 29, 2009 3:52 PM Always use the question type so people get credit for their replies to you
    Monday, June 29, 2009 12:25 PM

Answers

  • Hi Hari,

     

    I suggest you read the document Plan for software boundaries (Office SharePoint Server) when you plan the document transfer.

    http://technet.microsoft.com/en-us/library/cc262787.aspx

     

    If you plan to upload these documents to one site collection, the content database which holds the content of the site collection may increase to more than 100GB. Just as the technet document mentions that “we discourage the use of content databases larger than 100 GB” as it will affect the manageability and performance of your system. Then you may need to split the content database

    Move site collections to a new database (split a content database) (Windows SharePoint Services 3.0)

    http://technet.microsoft.com/en-us/library/cc825327.aspx

    Or follow the guide line if your design really requires a content database more than 100GB.

     

    Note: The limits we recommend apply only to a server running SQL Server 2005 hosting Office SharePoint Server 2007, and are not general guidance for SQL Server 2005.

     

    Hope this helps.

     

    Lu Zou

     

    • Marked as answer by Lu Zou-MSFT Tuesday, July 7, 2009 9:39 AM
    Wednesday, July 1, 2009 7:23 AM

All replies

  • Moving to the normal Admin forum. There's nothing specifically ECM about this imo.
    WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx
    Monday, June 29, 2009 2:36 PM
  • Hi Hari2009

    If you have some files with huge size check the limitation of the file size that can be uploaded four your site collection. You can extend the size using STSADM commands

    How are you planning to upload the files?


    Raghavan
    Tuesday, June 30, 2009 2:51 PM
  • Hi Hari,

     

    I suggest you read the document Plan for software boundaries (Office SharePoint Server) when you plan the document transfer.

    http://technet.microsoft.com/en-us/library/cc262787.aspx

     

    If you plan to upload these documents to one site collection, the content database which holds the content of the site collection may increase to more than 100GB. Just as the technet document mentions that “we discourage the use of content databases larger than 100 GB” as it will affect the manageability and performance of your system. Then you may need to split the content database

    Move site collections to a new database (split a content database) (Windows SharePoint Services 3.0)

    http://technet.microsoft.com/en-us/library/cc825327.aspx

    Or follow the guide line if your design really requires a content database more than 100GB.

     

    Note: The limits we recommend apply only to a server running SQL Server 2005 hosting Office SharePoint Server 2007, and are not general guidance for SQL Server 2005.

     

    Hope this helps.

     

    Lu Zou

     

    • Marked as answer by Lu Zou-MSFT Tuesday, July 7, 2009 9:39 AM
    Wednesday, July 1, 2009 7:23 AM
  • Hello Hari,

    i would check the following...

    * Space on SQL Server enought
    * Whats whith Transaction Log? Probably set it to simple mode during the upload
    * When tu upload the documents / userload in the time fram?
    * Max upload size settings in General Web Application Settings
    * What would search do when it hits the 80GB??? Search Databases big enought?
    * Are there any Quotas defined in Web Application / Site Collection / database Files or Transaction logs?
    * What are the limitations of SharePoint? 100GB Database / 2000 max files in a document libary
    ......

    Greetings,
    Andreas

    Wednesday, July 1, 2009 2:02 PM
  • Hi Raghavan,

    Thanks for your reply.
    the files which i will upload are not in hufe size but i have lot(more than 100GB) of files to be uploaded in sharepoint with more subfolders.
    I read if database size exceed 100GB then performance will go down and in that gave a solutions to go for seperate sitecollection.
    But my requirement is i need to maintain all documents in single site collection so still i can't able to get any solution to how to implement my requirement.
    Thursday, July 2, 2009 12:03 PM
  • Hi LuZou,

    I too read that content database should not exceed more than 100GB if so performance will go down.
     
    Below is the solutions given in that article.
     
    Whenever possible, we strongly advise that you split content from a site collection that is approaching 100 GB into a new site collection in a separate content database to avoid performance or manageability issues.

    Thanks for your timely support of sharing the article to move the site collection to a new database.

    Will try the steps given in this article.

    Thanks a lot for your support.

    Hari
    Thursday, July 2, 2009 12:10 PM
  • Hi Andreas,

    Thanks for your reply.
    Will conside all above mentioned point before i start implementing my requirement.
    Below are my first 2 actions.

    I need to first increase database server memory size.
    Next i need to find the alternate solutions if my content database size exceeds 100GB.

    Regards,
    Hari
    Thursday, July 2, 2009 12:29 PM