More in this section

Forums / Developing with Sitefinity / Using SQL Server FILESTREAM for document storage

Using SQL Server FILESTREAM for document storage

2 posts, 0 answered
  1. Alessio S.
    Alessio S. avatar
    37 posts
    31 May 2010
    30 Oct 2014
    Link to this post

    Is it possible to configure the Sitefinity database so that all binary data for documents, images etc. is handled with FILESTREAM columns instead of varbinary columns? Which are the tables and columns used for binary data storage?

    Thank you,
    Alessio Scalerandi

  2. Svetoslav Manchev
    Svetoslav Manchev avatar
    735 posts
    06 Sep 2017
    04 Nov 2014
    Link to this post
    Hello Alessio,

    The media files (docs, images, etc) are stored in the database as binary data in chunks. The data is saved in table 'sf_chunks'.

    In case you want you can change the Storage Provider and/or create a custom one which could covers your needs.

    Svetoslav Manchev
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
2 posts, 0 answered