Paul, Yes I've looked at that on Codeplex. There is a standard "interface" that reads/writes data to NTFS or you can in fact write your own or buy in a 3rd party driver of course.
I'm just confused as to if the implementation has an effect on the end user program (the app) or are the fields still stored as varbinary(max) which makes it invisible to the end user app. The examples M$ puts forward are somewhat obscure. I've downloaded the M$ paper "Remote Blob Storage" which I am going to dissect this morning. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Paul Hill Sent: 13 March 2014 19:30 To: ProFox Email List Subject: Re: [NF] M$ SQL Server Remote Blob Store On 13 March 2014 16:37, Dave Crozier <[email protected]> wrote: > Gentlemen, > Has anyone out there had any dealings with Remote Blob Storage on SQL Server > 2012? > > Our main document database is now approaching 2Tb of scanned documents that > We hold as Standard SQL Blob fields within the SQL Database. However this > makes backup/restoration of the database very long winded and I have been > looking at storage of the Blobs (documents/scans) on an external device > outside SQL which we can easily mirror e.g 2 x NAS storage units. In this > way we could do more backups/snapshots of the Database during the day. I am also facing a similar situation. I'm looking into FILESTREAM. Currently I store documents in a filesystem, which is less than ideal. http://technet.microsoft.com/en-us/library/bb933993%28v=sql.105%29.aspx "FILESTREAM integrates the SQL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object (BLOB) data as files on the file system. Transact-SQL statements can insert, update, query, search, and back up FILESTREAM data. Win32 file system interfaces provide streaming access to the data." -- Paul [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
