Contents
SQL Server Content Database
1 Answer. 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.
Content Database
They are stored in the Content Database on SQL Server. There are provisions to offload the files to the file system and third party tools to assist with it. Files that you upload within SharePoint to Document libraries are normally stored within SQL server.
Alternatively, you could look in the recycle bin on the SharePoint site. For windows 7 (IE9) and Moss2010 and office 2012 they are also in your temporary internet files (C:\Users\%userprofile%\AppData\Local\Microsoft\Windows\Temporary Internet Files).
How to open a document in forsharepoint server?
ForSharePoint Server 2010, click the down arrow on a file, click Send to, and then click Download a copy. In your browser, click Save, and then Open folder to open the folder where the file is located. Right-click the file in the desktop folder, and then click Open With.
How to open documents from SharePoint document library?
If you run into issues opening Office files and documents from SharePoint document libraries, here are some suggestions to help you fix them. You might consider syncing your document library with your computer to work with documents. Syncing creates a local folder on your desktop machine where you can open and edit files easily.
In SharePoint, select the file, and click Download on the command bar, or click the ellipses ( …) and then click Download. In SharePoint Server 2016, select a file, click More on the command bar, and click Download, or right-click the document, and then click Download.
For SharePoint Server 2013, select a file, click the ellipse ( …) click the ellipse (…) again in the dialog, and then click Download. ForSharePoint Server 2010, click the down arrow on a file, click Send to, and then click Download a copy.