How to change the folder used for FileStream?

• Frank Cazabon

  Hall of Fame

  Points: 3467

  More actions

  August 8, 2011 at 9:12 am

  #245790

  Hi,

  I am using SQL Server 2008 R2 and am trying to make use of the FileStream facilities for storing documents. I'm a real novice at this (but am a programmer by profession, just not a SQL DBA).

  I have it working on my PC, but when moving the database to my client's site I need to tell it to use a different folder. How do I do this?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738642

  More actions

  August 8, 2011 at 10:07 am

  #1365332

  Looks like when doing the restore or attach, you alter the location there.

  http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/ff8c14ae-a9d0-4668-a95b-ee19bbb48b26/

• Frank Cazabon

  Hall of Fame

  Points: 3467

  More actions

  August 8, 2011 at 11:01 am

  #1365390

  Thanks. Will doing that mess with the security setup on the database?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738642

  More actions

  August 8, 2011 at 11:07 am

  #1365403

  No, the changing of the location during attach or restore shouldn't affect that.

• Frank Cazabon

  Hall of Fame

  Points: 3467

  More actions

  August 8, 2011 at 11:37 am

  #1365417

  Thanks Steve,

  so far it looks like it has worked, now to let the users at it 🙂