?
Solved

sharepoint and files

Posted on 2012-08-22
4
Medium Priority
?
370 Views
Last Modified: 2012-08-22
say i have a sharepoint server, and i have people uploading their documents to the server, as default, sharepoint will convert the file to binary and store it in wscontent database. i can turn that off and allow the document to be uploaded into a file server. My question is what is the best approach to do this? do i let the database grow so big or do i let them upload the documents to file server. what is the right way or most common or most efficient way to do this? thanks
0
Comment
Question by:StewSupport
  • 2
  • 2
4 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 2000 total points
ID: 38320328
Hi,
I think you mean the "Remote Blog Storage" (RBS) option which is using SQL Server file stream feature to store the content on a file share, having internally just the pointer to that file.
A good overview is here:
http://www.simple-talk.com/dotnet/.net-tools/sharepoint-2010-storing-documents-on-the-file-system-with-remote-blob-storage/

You would have to consider security and operational aspects (e.g. if storage space is getting low).

HTH
Rainer
0
 

Author Comment

by:StewSupport
ID: 38320848
reading this article i noticed on the backup part where he said if RBS provider support Native SQL BLOB, the BLOB will be in the backup as well. So does this mean that if i use FileStream BLOB, i don't have to include BLOB in the database backup?
0
 
LVL 44

Expert Comment

by:Rainer Jeschor
ID: 38320960
Hi,
as long as you are using SharePoint backup, the content will be backup regardless if the content is in the database or remotely.
http://blogs.msdn.com/b/opal/archive/2010/03/24/faq-sharepoint-2010-remote-blob-storage-rbs.aspx

RBS planing:
http://technet.microsoft.com/en-us/library/ff628583.aspx

And another interesting whitepaper:
http://www.microsoft.com/en-us/download/details.aspx?id=14726

BTW, RBS can only store on local drives, not on SMB shares.

HTH
Rainer
0
 

Author Comment

by:StewSupport
ID: 38321038
yeah i saw. but if your server was a vm wouldn't c drive a san?
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question