Post reply

SQL Server 2012 Filestream

  • July 16, 2015 at 2:26 am

    #302363

    Hi All,

    We have a server with a database with filestream enabled. The filestream data is in a filegroup with three files spread across 3 LUNs F:, G:, and H: each with a capacity of 1.8 TB.

    The file stream containers in those three LUNs reference the same column in the same table.

    The F: Drive has only 64 GB free space left. The H: However has around 700 GB free.

    We are looking to move some filestream content from the container in F: to the container in H:.

    Firstly, Is this possible, If so, Could anyone suggest a recommended approach for this?

    Thank you in advance. Would really appreciate some insight.

    thanks,

  • July 17, 2015 at 3:35 am

    #1813206

    Hi,

    did not want to leave this topic incomplete as this might be useful to someone else.

    We logged a ticket with Microsoft Premier Support for this and the answer to my question is a NO. moving entire containers is possible (like moving standard .mdf and .ldf to different directories) but moving some content is not possible.

    thanks,

  • July 17, 2015 at 5:44 am

    #1813239

    Thanks for the update. We are currently investigating all interesting facts about FILESTREAM. Your update will be added to our documentation 😉

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

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

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