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. However,I am somewhat confused as to what changes to the loading of Blobs from the application will make, if any. Is the RBS system simply dealt with by the internal mechanics of SQL server or do you need to file stream the data from your app directly onto the RBS device. The white papers from M$ don't make this clear. Dave _______________________________________________ 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.
