Post reply

HOW TO MOVE FILESTREAM's FILES FROM ONE LOCATION TO ANOTHER LOCATION?

  • October 12, 2017 at 6:10 am

    #402591

    Hi All,

    I have requirement File table directory need to be changed with another location and do not change Stream id while moving. because Sream id only have refereed with other couple of tables. 

    How to achieve it?

  • October 12, 2017 at 9:24 am

    #1963406

    I'm not sure what you mean here. You want to move the physical data? Or the share? Or what?

    You should have a filestream/filetable that has a share. something like \\myserver\myshare\

    There is then a data folder somewhere, which contains the actual files. This is only referenced by SQL Server. This is usually under your data file, unless you created the filegroup in a different location.

    Your data is in a filegroup. You  can do a few things.
    1. backup/restore , using WITH MOVE to move the filegroup.
    2. detach/attach - same thing, move the data folder for the filegroup, attach from a new location
    3.  create a new filegroup for FILESTREAM, move (rebuild) the table on this filegroup.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply