FileTable Part-2

Now we are at part2 of FileTable .

You can go for part1 from here

In Part1 We learn how to configure server to use of FileSteam.

Now we will create a database where we will use FileTable

•  Lets create a database named FileTest
• Go to property of FileTest Database

1.Set FILESTREAM Directory Name to FileTableExampleDir
2.Set access to Full/Read-Only
In this example we are going to set it FULL

Now we have enabled database for filestream access.

• Now we need to add filegroup for filestream access.

       Go to property of Database – > FileGroups

   Now add a file to file group fileFG

       Make This File Group as default