locked
FILESTREAM Directory path: RRS feed

  • Question

  • Hi,

    I was trying to enable Filetable in SQL 2012. I've to do as below to enable the file table.

    In the database property, I've given the FILESTREAM Directory Name as shown below:

    I wanted to know in which location or path this directory will get created (by default)? Also, what is the use of this directory?

     

    Thanks,

    Santosh

     

    Friday, January 13, 2012 8:36 AM

Answers

  • Thanks. I'm able to get the filestream directory path.
    Wednesday, January 18, 2012 9:59 AM

All replies

  • A shared folder will be created in directory name which you are mentioning in the File Stream Directory.

    To see the shared directory , Go to Start --> Run

    Type \\<<MachineName>>

    The use of this folder is all the file tables and file stream objects created will be stored under this shared folder.

    Friday, January 13, 2012 9:13 AM
  • Thank you very much Sorna. Although I'm trying to accessing in my local machine, I'm getting message "You do not have permissions to access..." and I couldn't the get the shared folders in my local machine. Can you please let me know if there is any other setting required.

     

    Thanks,

    Santosh

    Friday, January 13, 2012 9:29 AM
  • If you have create a FileTable, find it in Object Explorer in SSMS. The context menu you should give you an option to open the share.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Friday, January 13, 2012 10:52 PM
  • Thanks Erland. Yes the filetable got created successfully and I'm able see the new filetable under the FileTables in the object explorer in SSMS.

    But “Explore FileTable Directory" option is disabled in my case. (Right click on the created filetable in the object explorer). Can you please let me know how to enable the option “Explore FileTable Directory"?

     

    Or let me know how can I get the path of the filetable that got created. (I’m unable to find in my machine)

    Thanks,

    Santosh




    Tuesday, January 17, 2012 4:32 AM
  • Thanks. I'm able to get the filestream directory path.
    Wednesday, January 18, 2012 9:59 AM