Moving FileStream data to new location

• Aspet Golestanian Namagerdi

  SSCarpal Tunnel

  Points: 4444

  More actions

  November 7, 2011 at 6:19 pm

  #390789

  We have SQL SERVER 2008 R2 and in one of our tables we have used FileStream feature.Now we want to change the location of FileStream,What is the correct way to do that?

  I want to create a new FileGroup and FileStream File Pointing to new location and then create the same table with other name on new FileGroup and then transfer the data from old table to new table and finally remove the old table and rename the new one.

  Is this right approach?

• prvmine

  SSCertifiable

  Points: 7007

  More actions

  November 7, 2011 at 7:49 pm

  #1404242

  have you looked at either of these links

  http://blogs.msdn.com/b/sriramg/archive/2010/06/03/moving-filestream-data-to-new-location.aspx

  http://www.mssqltips.com/sqlservertip/1878/how-to-detach-and-attach-a-sql-server-filestream-enabled-database/