We have an document management application uses SQL Server 2012 to store document index information and uses a Windows file share to store the documents. We are working on migrating to store the documents within a SQL FileStream. However, we have encountered one issue.
It states that “It is not possible to back up a single file as a unit of the filegroup or to restore a single file from the filegroup backup. Keep in mind that you can export a single file when you restore the primary filegroup and then the FILESTREAM backup to a separate instance“.
There are numerous times when a client asks us to restore a single file because they accidentally modified it. With our current system (using a Windows file share that is backed up continuously) we can go to our backup system (Microsoft DPM) then select and restore just a single file to it's original location. If we use FileStream to store the documents within SQL, how can we restore just one document, not the entire database?