http://blogs.technet.com/b/dataplatforminsider/archive/2008/04/14/sql-server-2008-makes-it-easy-to-manage-blobs-and-files.aspxOne of the most exciting new features in SQL Server 2008 is the ability to store files and BLOBs directly in the file system, while maintaining transactional consistency with a SQL Server 2008 database. SQL Server 2008’s new FILESTREAM attribute for VARBINARYen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/dataplatforminsider/archive/2008/04/14/sql-server-2008-makes-it-easy-to-manage-blobs-and-files.aspx#3567474Wed, 17 Apr 2013 20:58:10 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3567474Eduardo Ponzoni<p>Old (it&#39;s now 2013), but such a great article! </p> <p>I didn&#39;t notice that feature, and within my last job, I used a similar approach which consists of saving the file path to the DB and file in file system. But the problem is that our backup and restore procedures became harder to maintain, but perhaps using that feature you suggested on this post, many of those issues would be sorted out.</p> <p>Great job mate!</p> <p>Thank you for sharing that with us!</p> <p>PS.: About the previous comments, I would say that it&#39;s my belief that companies would go for SQL Server Express only for testing purposes. for real production environment, they should use the full version.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3567474" width="1" height="1">http://blogs.technet.com/b/dataplatforminsider/archive/2008/04/14/sql-server-2008-makes-it-easy-to-manage-blobs-and-files.aspx#3528625Thu, 25 Oct 2012 12:07:06 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3528625Dan<p>Shashwat, SQL 2008 R2 Express max DB size is not 1GB...its 10GB.</p> <p>That being said, i&#39;m sure this article is referring to those who have full SQL, not express. In full SQL your database size is only limited by the hard drive space on the SQL server where the DB files are stored.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3528625" width="1" height="1">http://blogs.technet.com/b/dataplatforminsider/archive/2008/04/14/sql-server-2008-makes-it-easy-to-manage-blobs-and-files.aspx#3458775Wed, 12 Oct 2011 10:12:34 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3458775Shashwat Tripathi<p>We should not store large files in database, specially for SQL 2008 R2 Express edition. Maximum database size is 1GB here.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3458775" width="1" height="1">