Tag Info

New answers tagged


To completely remove FILESTREAM features from a database, you need to perform the following steps. Delete all FILESTREAM columns from all tables Disassociate tables from FILESTREAM filegroups Remove all FILESTREAM Data Containers (filegroup files – you might have more than one of them) Remove all FILESTREAM filegroup (there may be more than one of them) ...


According to Paul Randal (who is as reliable as they come) there is no simple way to do this and you essentially have to recreate the table in a new filegroup that is pointed to your new filestream location. The link is there so you can see for yourself, but this looks like the only real alternative. It is not an ideal one, obviously but it should get you ...

Top 50 recent answers are included