Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Aug 30 '11 at 9:18

This question came from our site for professional and enthusiast programmers.

2 Answers 2

  1. Alter database modify file setting the new path. The file/file group will be set to offline.
  2. Manually copy the Filestream container to the new location specified in (1).
  3. Bring the file/file group back online.

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.

share|improve this answer

One solution can be found here.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.