OOC are you using SQL Server Enterprise Edition?
This whole RBS / FILESTREAM area is a bit of a mess with lots of miscommunication, etc. And don't get me started on this 200GB content database BS. The person(s) responsible for http://technet.microsoft.com/en-us/library/cc262787(v=office.15).aspx should be sacked for all the confusion, contradictions and misinformation contained therein. As one of MANY examples of WTF statements in the URL I don't understand why you would even use RBS if "the total volume of remote BLOB storage and metadata in the content database must not exceed the 200GB limit.", what would be the point? I don't think they have come close to clarifying the situation and what they mean by "supported" and what Microsoft will "support". I would start with the size of your CAD BLOBs and see how large they are. If they are 10GB, do you really want to be channelling them through your WFEs? What frequency will people be accessing data through the share versus SPS? What will be the read / write percentage? And of course, as always what is the performance profile of your storage solution? Other very important factors would also be the potential benefits of WS2012: * Storage spaces * Deduplication (I don't know enough about CAD files to comment here) * SMB 3.0 enhancements Bottom line I think that you would not use the FILESTREAM provider for RBS. AvePoint, Metalogix/StoragePoint, Quest, etc all have far better RBS providers. My AUD $0.02: HTH, Victor From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 1:56 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Well I can disable download availability per library thank goodness. But the following limitations are potential blockers unless there's an easy way to expand out to new databases as each one fills up. * The use of RBS-enabled content databases larger than 200GB with collaboration sites is not supported. o Not entirely sure what's meant by "collaboration" unless they're referring to the Team Site template. * If you are using Remote BLOB Storage (RBS), the total volume of remote BLOB storage and metadata in the content database must not exceed the 200GB limit. o Am I right in assuming this does not include the files themselves?? * You cannot upload any document larger than 2GB to an RBS-enabled content database. o Pretty sure this will be the case for CAD project files. If they're talking about terabytes worth of content then I have limited options. They're not after a SharePoint user experience. They just need a way to access and dump files. I think metadata is also unrequired. Third party apps always bite me on the ass come upgrade, so it looks like a customer connector is probably the only avenue left to me. Regards, Paul From: ozmoss-boun...@ozmoss.com <mailto:ozmoss-boun...@ozmoss.com> [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Ivan Wilson Sent: Monday, 18 August 2014 1:44 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library My experience with OneDrive for Business has been very poor. It only supports a limited number of files and folders in a sync location (20,000 in your My Site library, 5,000 in other libraries - link <http://support.microsoft.com/kb/2933738> ). It has constantly run into issues for me, with the only option being to start syncing again from scratch. There are third party products out there that expose a file share as a document library. I know AvePoint have one. This will complicate your backup/restore/DR strategy though. I've also found that exposing an existing file share as a document library isn't always a wonderful experience. You won't have any metadata (initially at least) and a deep folder structure is a poor user experience in SharePoint. I recently saw a presentation from CADAC. These guys specialise in linking CAD drawings with SharePoint. One of their products (Organice <http://www.cadac.com/organice/en/solutions/Pages/default.aspx> ) will link AutoDesk's Vault repository with SharePoint. Vault seems to be a common product used by people that work with drawings, but the licencing gets pricey. CADAC's Organice allows people that don't have Vault licences to access and review drawings. I haven't used these products, so don't have any practical experience to share. Ivan From: ozmoss-boun...@ozmoss.com <mailto:ozmoss-boun...@ozmoss.com> [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of James Boman Sent: Monday, 18 August 2014 12:35 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul, Does using SharePoint synch button on a library physically copy the entire library to the local PC? Yes - as far as I know it will copy the entire library to the local machine for offline use. Dumping of files into the same path will cause OneDrive for Business upload them in the background. I find this feature very handy. Can I specify a UNC path to a remote server using FILESTREAM? >From my understanding, the FILESTREAM feature of SQL server is an implementation (not the only one) of the BLOB storage API in SharePoint. A document library in a content database with FILESTREAM enabled behaves no differently from a user point of view. While you can see the filesystem that SQL uses to store the BLOBs, you can't/shouldn't make changes to that filesystem. Mapping of UNC paths would continue to work the same way it does for all document libraries (via WebDAV) using open in explorer mode ribbon button or using the connect to website feature in the map drive dialog. Kind regards, _____ James Boman │ Phone: <callto:+61872001100> +61872001100 │ Mobile: <callto:+61417857298> +61417857298 │ Skype: <callto:JDBoman> JDBoman │ Web: <http://www.ipmo.com.au/> www.ipmo.com.au From: <mailto:ozmoss-boun...@ozmoss.com> ozmoss-boun...@ozmoss.com [ <mailto:ozmoss-boun...@ozmoss.com> mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 11:55 AM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Hi James, I'm open to both. My understanding is they want to a way to easily access or dump files (when offline) for these types of files. * Does using SharePoint synch button on a library physically copy the entire library to the local PC? * Can I specify a UNC path to a remote server using FILESTREAM? Regards, Paul From: <mailto:ozmoss-boun...@ozmoss.com> ozmoss-boun...@ozmoss.com [ <mailto:ozmoss-boun...@ozmoss.com> mailto:ozmoss-boun...@ozmoss.com] On Behalf Of James Boman Sent: Monday, 18 August 2014 12:16 PM To: ozMOSS Subject: RE: Use a newtwork share as the source for a document library Paul, Have you considered using FILESTREAM storage on the SQL server for storing the files as files, while still keeping the benefits of housing them in a SharePoint document library? Cheers, James. _____ James Boman │ Phone: <callto:+61872001100> +61872001100 │ Mobile: <callto:+61417857298> +61417857298 │ Skype: <callto:JDBoman> JDBoman │ Web: <http://www.ipmo.com.au/> www.ipmo.com.au From: <mailto:ozmoss-boun...@ozmoss.com> ozmoss-boun...@ozmoss.com [ <mailto:ozmoss-boun...@ozmoss.com> mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Paul Noone Sent: Monday, 18 August 2014 9:56 AM To: ozMOSS Subject: Use a newtwork share as the source for a document library Hi all, Has anyone successfully achieved this? I have terabytes worth of CAD files and other types that are simply not suitable to storing in a DB. I want to provide a Document Library view of this location and provide basic read/write (upload) functionality. Would my best option be a custom BCS connector that interacts with the file system directly? Regards, Paul The content of this email is confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to, or used by, anyone other than this addressee, nor may it be copied in any way. If received in error, please contact the author and then delete the message from your system. Please note that neither Keller Australia nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Visit <http://www.keller.com.au/> http://www.keller.com.au/ for more information. _____ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal _____ The content of this email is confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to, or used by, anyone other than this addressee, nor may it be copied in any way. If received in error, please contact the author and then delete the message from your system. Please note that neither Keller Australia nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Visit <http://www.keller.com.au/> http://www.keller.com.au/ for more information. _____ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal _____ The content of this email is confidential to the intended recipient at the email address to which it has been addressed. It may not be disclosed to, or used by, anyone other than this addressee, nor may it be copied in any way. If received in error, please contact the author and then delete the message from your system. Please note that neither Keller Australia nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any). Visit <http://www.keller.com.au/> http://www.keller.com.au/ for more information. _____ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal _____
_______________________________________________ Sponsored by Infotext - Amazing Search for Microsoft SharePoint - http://www.infotext.com/ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
