Note : If your database is already created, you can set FileStream stuff by right click your database and then properties and then file group.
In the period of SQL Server 2005 when we want to store some files to the database we can have that using varbinary(max) but that approach is not either smart nor popular amongst the developers.
Prior to SQL Server 2008, we had a datatype called ".Well, from past two days I am working on SQL Server 2008 new feature called File Stream.This database will have new special type of filegroup which is called filestream once upon a time season 1 episodes filegroup.Merge replication includes an optimization for replicating large object types.The old file must be preserved until it is no longer needed for recovery purposes, likewise files representing deleted filestream data, or rolled-back inserts of filestream data, are also similarly preserved.When you open a FileStream Data Container, in other words the folder, you'll see the following 2 things: fslog Filestream.The other articles in the series are.The new SQL Server 2008 filestream data type enables SQL Server applications to store unstructured data, such as documents and images, on the file system with a pointer to the data in the database.This is because of the extra overhead of backing up each ntfs file (one per filestream data value).Earlier, the size of blob data is limited to 2 GB only but in FileStream it's not.Figure 1: Windows File, as in the preceding image I tried to show how earlier things were saved in a data file, but in a FileStream all files are stored in your drive and its location is entered in a table as a pointer.
Right click on SQL Server Service, click on Properties and then select filestream tab.
If you compare the original file with this stored file, you'll find everything is the same.
This is considered to be the best approach because a SQL Server buffer is not used in this process and therefore this memory can be used or is available for query processing.
Once you add that, Go to the Files and add a new file.
If you installed a SQL Server instance without enabling FileStream then do not to worry.
If you have not enabled filestream feature during installation, there is no problem you can do so using SQL Server Configuration Manager as discussed below.We recommend that you replicate the filestream attribute, unless you are replicating data to SQL Server 2005. .For using the FileStream, you need to add a File Stream Group here and make it default.SQL Server has always provided the capability to store blob data into a SQL Server varbinary column.When data-type compatibility is set to 80, client behavior will be consistent with down-level client behavior.Ok, let me brief you the option we have here.This option can be used to control the size of filestream data that is replicated.Note: For developers who are coming from a SQL Server 2000 background, Microsoft recommends using the MAX data types instead of blobs (text, ntext and image) in SQL Server 2008 as blobs are being deprecated in future releases of SQL Server.To specify that a column should store data on the file system, you specify the filestream attribute on a varbinary(max) column.Now, when we execute the preceding query, SQL Server will create a folder where it'll store the files.Execute the following query to configure FileStream.Figure 8: DataBase On the General tab, give your database a name and owner of your choice.If you add a filestream column to a table that is already published for merge replication, we recommend that you set the option to true by using sp_changemergearticle.