Windows Server

Fisheye · Guest

Hi,
I have a query regarding the way things are stored in sharepoint on SBS
2003.

I have talked to people who believe that because sharepoint uses SQL, it
stores
the documents in binary blobs within the database.

I believe that it uses the normal file structure and sharepoint stores only
the path
of the files and file meta data.

Is someone able to clarify this or supply a link that gives the tecnical
details
of sharepoint storage and using the sharepoint views in windows explorer?

TIA,
-Jamie

David Copeland [MSFT] · Guest

Jamie,

Files uploaded/links etc added to Companyweb/Windows SharePoint Services
(WSS) are stored into the database. And as mentioned Word documents for
example, would be stored as a BLOB into a field into one of the tables.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_SP2003_ta/html/ODC_WSSArchitecture.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/spptsdk/html/tsdbTables.asp

http://www.microsoft.com/downloads/details.aspx?FamilyID=a637eff6-8224-4b19-a6a4-3e33fa13d230&DisplayLang=en
http://www.microsoft.com/downloads/details.aspx?FamilyID=aa3e7fe5-daee-4d10-980f-789b827967b0&DisplayLang=en

Keep in mind that the only supported methods to programatically access the
WSS content is via either the SharePoint object model or using the
SharePoint Web Services.

If you were referring to SharePoint Team Services, then docs were stored
into a directory and information about the file was stored in the database.

---

Hope that helps,
David Copeland
Microsoft Small Business Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.

Newsgroups:
SBS v4.x : microsoft.public.backoffice.smallbiz
SBS 2000: microsoft.public.backoffice.smallbiz2000
SBS 2003: microsoft.public.windows.server.sbs

"Fisheye" <support@fisheye.net.nz> wrote in message
news:eyZg9Hp9EHA.2788@TK2MSFTNGP10.phx.gbl...

Fisheye · Guest

That's very interesting, thank you for helping to clear up that.

When you have a windows file tree that you want to import into sharepoint
services,
does it import them all in to the SQL Server 2000 database (if you have SQL
installed)?

Regards,
Jamie

"David Copeland [MSFT]" <davidcop@online.microsoft.com>

Mike Walsh · Guest

Yes. But it's not really a good idea to do it this way as support for
folders within document libraries isn't particularly good.

Instead create different document libraries and copy the contents of one
folder into one document library (or several folders into one document
library specifying a field like category to divide the various sets of
documents into Views).

Note: If you have questions like this that are standard WSS questions that
do not rely on the presence of SBS 2003 in any way, please post them only to
the WSS newsgroup - similarly questions that do depend on the presence of
SBS 2003 should go only to the SBS newsgroup.

Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please post questions to the newsgroup only.

"Fisheye" <support@fisheye.net.nz> wrote in message
news:ezDZXBs9EHA.3120@TK2MSFTNGP12.phx.gbl...

Ian Morrish · Guest

Web-DAV is also a supported method for accessing the documents.
This means that you can add a shortcut to the document library in your
Network Places.

Regards,
Ian
http://www.wssdemo.com

"David Copeland [MSFT]" <davidcop@online.microsoft.com> wrote in message
news:egOBPur9EHA.2180@TK2MSFTNGP12.phx.gbl...

	Windows Server Forum Index -> Windows Services	All times are GMT
Page 1 of 1