Using SQL Server FILESTREAM for document storage
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
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.
Regards,
Svetoslav Manchev
Telerik