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.
Sql-server – Change SQL Server FileStream Path
filestreamsql serversql-server-2008
Related Topic
- Sql-server – Migrating from filestream to “classic” blob
- How to backup/restore excluding filestream varbinary in SQL Server 2008
- Sql-server – An mdf file of a Sql server 2008 database is bigger than expected
- Sql-server – SQL Server: How to shrink FileStream files
- SQL 2016 – FILESTREAM feature is disabled. (bogus message)
Best Answer
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.