I would like to change the path for a SQL Server Filestream but I can't find any information on this. I know how to change the mdf and ldf filenames, but can't seem to find how to change the folder name where the FileStream stores the data.
migrated from stackoverflow.com Aug 30 '11 at 9:18
This question came from our site for professional and enthusiast programmers.
Starting with Sql Server 2008 R2 you can do the operation online by adding a second Filestream container (located in the new folder) to the current file group, then shrink the original container (WITH EMPTY option). Once all data is migrated and garbage collected so that the original container is empty, you can remove it from the Filestream file group.