I'm still fairly new to SQL Server Admin and DB design, however, I've been tasked with finding a solution for a customer. The scenario is as follows: The customer has a 7TB database in which most of that size is due to BLOB data (certification documents). We are currently combing their 4 databases into a single database. They'd like to archive all documents that are older than 12 months but still need to access them. My first two thoughts were FileTables and Remote BLOB store utilizing Storage Spaces Direct.
Does anyone have any additional input on this as to which route to go down, or suggesting something I haven't thought about? The idea behind S2D was so that they can grow their storage as needed. Being able to access the files as if they were right on their desktop is appealing as well.