Link to home
Start Free TrialLog in
Avatar of Member_2_6313995
Member_2_6313995

asked on

Storing a Large Number of Files in SharePoint & how to Manage them

Hey Everyone,

I was hoping to start some dialogue about SharePoint 2010 and the new Document Management capibilities that come along with it.

I work at a mid-sized business with 40+ employees with our business producing quite a few new documents a day (100+) mainly comprised of emails, word Documents and/or PDFs.

We're using file shares to store these files but should like to move these files into SharePoint the thing is we are finding it hard to get information on what's required for SharePoint to store our exisitng 750GB+ (400,000+) doucments.

Most of the articles online seem to be focusing on the business benefits of storing documents in SharePoint, which we are already feelng pretty confident that we understand, just not so confident on the idea of how SharePoint stores documents in a SQL database. We dont have experience managing databases 750GB+ or databases where transaction logs can bloat so significantly if a user was to upload a large scanned contract.

Does anyone have any experience dealing or using SharePoint as their primary document management system, storing and managing similar amounts of documents? We are a two man IT team and need to approach these things with caution.
Avatar of ImaCircularSaw
ImaCircularSaw
Flag of United Kingdom of Great Britain and Northern Ireland image

SharePoint stores files in it's content database as a binary stream.  There is the option to hold files in a BLOB on a file system that's managed by the database server, however, I would only recommend this for large media files.

The best thing with SharePoint is that you can off-load most of the migration work to users.  You should help them build an appropriate document storage structure then they should be able to do the document migration themselves.  This can be done on a per document basis or you can view a document library in windows explorer and drag/drop a number of files at a time.

If you have some more specific questions about your concerns I could answer them.

One word of warning, there is very rarely a real reason for using folder inside document libraries, try to avoid using them now as later down the line they'll cause problems.
ASKER CERTIFIED SOLUTION
Avatar of Justin Smith
Justin Smith
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Member_2_6313995
Member_2_6313995

ASKER

This is the sort of answer IT departments of a lot of companies are looking for. I think the functionality of SharePoint merits purchasing and investing in the product. However, as the business side of a company look at some of the other capabilities they start saying "why don't we do our document management in SharePoint".

Unfortunately we find that Microsoft spends more time advertising that SharePoint can handle millions of files, but not such a good job of documenting how and what involved resource wise (people, software and time). It would seem that the internet is riddled with a lot of SharePoint enthusiasts that have more faith than experience in this area.
I am going to look into StoragePoint, thank you ACH1LLES.
No problem.  If you need assistance implementing the RBS solution, I'm available.  My email address is in my profile.