SharePoint Products > SharePoint Products and Technologies Forums > SharePoint - Enterprise Content Management (pre-SharePoint 2010) > ECM storage: store Office document in MOSS 2007 or in SHared Network Drive indexed by MOSS ?
Ask a questionAsk a question
 

AnswerECM storage: store Office document in MOSS 2007 or in SHared Network Drive indexed by MOSS ?

  • Tuesday, July 14, 2009 1:45 AMAlbert Widjaja Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi All,

    At the moment I've got a shared network folder which contain thousand of MS Office files ~ 800 GB in size.

    I've already deployed MOSS 2007 and created a document library per project sites inside my top level site, but somehow still wondering of which solution is the best for me between the following options:

    Option 1: Dump all of the content into each of the respective project Document Library --> i know that it'll grow the MOSSContentDB into more than 800 GB

    Option 2: Do nothing and perform indexing on the shared network folder per each project folders.

    any suggestion and comment will be greatly appreciated.

    Thanks.
    /* Windows Infrastructure Support Engineer */

Answers

  • Tuesday, July 14, 2009 7:43 PMSerge Luca [MVP]MVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    -if you want your user to be able to retrieve you documents by searching with metadata and not just the files content, you have to import the files into document libraries, and don't forget that it is not a good mractice to have content db > 100 - 200 GB; you may have to split it up into several site collections ->several content db.
    -Otherwise, if you don't want to leverage metadata in search (which I doubt), keep the files in the shared drive.


    Serge Luca; blog: http://www.redwood.be
  • Thursday, July 16, 2009 7:32 AMSerge Luca [MVP]MVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Hi Albert,

    1°First off, read lambert Qin's answer.
    2°if you have several top level web site as indicated in your post
    <<
    i've already built multiple top level site on http://mossdev01:10001/ namely:

    http://mossdev01:10001/sites/PMO/default.aspx
    http://mossdev01:10001/sites/ProjectA/default.aspx
    http://mossdev01:10001/sites/ProjectB/default.aspx
    http://mossdev01:10001/sites/ProjectN/default.aspx
    >>

    Each top level web site is the root site of a site collection, ->you have several site collections
    You can read this article from Technet : Move site collections to a new database (split a content database)



    Serge Luca; blog: http://www.redwood.be

All Replies

  • Tuesday, July 14, 2009 7:43 PMSerge Luca [MVP]MVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    -if you want your user to be able to retrieve you documents by searching with metadata and not just the files content, you have to import the files into document libraries, and don't forget that it is not a good mractice to have content db > 100 - 200 GB; you may have to split it up into several site collections ->several content db.
    -Otherwise, if you don't want to leverage metadata in search (which I doubt), keep the files in the shared drive.


    Serge Luca; blog: http://www.redwood.be
  • Thursday, July 16, 2009 12:17 AMAlbert Widjaja Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi Serge,

    Thanks for the response, here's the current situation of my web apps looks like in IIS:
    http://mossdev01/ --> SharePoint 80
    http://mossdev01:9999/  -->CA
    http://mossdev01:10000/ --> SSP
    http://mossdev01:10001/ --> MySite
     
    i've already built multiple top level site on http://mossdev01:10001/ namely:

    http://mossdev01:10001/sites/PMO/default.aspx
    http://mossdev01:10001/sites/ProjectA/default.aspx
    http://mossdev01:10001/sites/ProjectB/default.aspx
    http://mossdev01:10001/sites/ProjectN/default.aspx


    So i need to create separate site collections per project like the following based on your suggestion like the following:

    http://mossdev01/PMO
    DB: ContentDB-PMO

    http://mossdev01/ProjectA
    DB: ContentDB-A

    http://mossdev01/ProjectB
    DB: ContentDB-B

    http://mossdev01/ProjectCN
    DB: ContentDB-N


    is that possible ?
    cmiiw from what i know

    one web application can only uses one ContentDB ?

    one SSP can only uses one ConfigDB and one SearchDB for indexing ?
    /* Windows Infrastructure Support Engineer */
  • Thursday, July 16, 2009 1:31 AMLambert QinMSFT, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    I answered your previous question in http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/1470df05-e0a0-42d3-9d96-5749e97f36d6

    Could you please check the answer there and let me know if you have any concerns regarding my answer?

    -lambert
    Sincerely,
    Lambert Qin | Microsoft TechNet Managed Forum Support
    Posting is provided "AS IS" with no warranties, and confers no rights.
  • Thursday, July 16, 2009 7:32 AMSerge Luca [MVP]MVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    Hi Albert,

    1°First off, read lambert Qin's answer.
    2°if you have several top level web site as indicated in your post
    <<
    i've already built multiple top level site on http://mossdev01:10001/ namely:

    http://mossdev01:10001/sites/PMO/default.aspx
    http://mossdev01:10001/sites/ProjectA/default.aspx
    http://mossdev01:10001/sites/ProjectB/default.aspx
    http://mossdev01:10001/sites/ProjectN/default.aspx
    >>

    Each top level web site is the root site of a site collection, ->you have several site collections
    You can read this article from Technet : Move site collections to a new database (split a content database)



    Serge Luca; blog: http://www.redwood.be