Sharepoint 2010 - where does it store the real files?

Question

Hi,

when I add a new document in sharepoint (*like word doc) where exactly the file (binary data) is stored?

In MS SQL engine? (BLOB?) On HDD as Native file?

Something else?

Thanks, Dmitry

Answer 1

By default, it is stored in the SQL Server Content Database associated with the site collection. However, Sharepoint 2010 does support storing list data as BLOBs in external storage.

See http://technet.microsoft.com/en-us/library/ee748607.aspx for more information.

 Tim