I have a server running SQL Server 2012 with Multiple Filestream containers on a single table.
I need to split one of the existing filestream containers into two parts by creating a new filestream container and moving the data across.
How can reliably move content between filestream containers?
I have the first container set to not grow any further but how can I move the files to another container without writing to a whole new table? Is there a way to do an
UPDATE statement that will cause SQL Server to write the file to disk again? - I have thought of appending an additional byte of data and then removing it afterwards to make SQL Server write the content as new files, but is there a better way?