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 _______________________________________________ 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/CADwx0+JmnLwqpDGrqK0fcDC6_2r8=z2fsiuoh1ggjnjow1x...@mail.gmail.com ** 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.
