Good explanation Victor. Thanks for this thread guys. Informative.
Sutha
0450076504
Sent from my iPhone
> On 18 Aug 2014, at 4:45 pm, "Victor Isakov"
> <vic...@sqlserversolutions.com.au> wrote:
>
> 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] 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). 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) 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] 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.
>
> <image001.png>
>
> Kind regards,
>
>
>
> James Boman ■ Phone: +61872001100 ■ Mobile: +61417857298 ■ Skype: JDBoman ■
> Web: www.ipmo.com.au
>
>
>
>
> From: 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: 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: +61872001100 ■ Mobile: +61417857298 ■ Skype: JDBoman ■
> Web: www.ipmo.com.au
>
> From: 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/ 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/ 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/ 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
_______________________________________________
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
_______________________________________________
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