SQL Server 2012 : Working with FileTables
Hi Guys, I had a requirement to store files in the database. But had an issue with storage as the files were growing, so my project leader asked me to come up with a solution. Then I found about FileStream and FileTables. So thought of sharing my experience. 1) Enable FileStream in your instance Go to Configuration Manager, select the instance -> Properties -> FileStream Tab 2) Enable FileStream on your Server Go to SQL Server Management Studio, select server -> Properties -> Advanced ->FileStream -> FileStream Access Level -> Full Access Enabled 3) Create Database with FileStream CREATE DATABASE Archive ON PRIMARY ( NAME = Arch1, FILENAME = 'd:\FileStorage\archdat1.mdf'), FILEGROUP FileStreamGroup1 CONTAINS FILESTREAM( NAME = Arch3, FILENAME = 'd:\FileStorage\filestream1') LOG ON ( NAME = Archlog1, FILENAME = 'd:\FileStorage\archlog1.ldf') GO 4) Specify File...