Re: Company Web Files, where are they?

[David Copeland [MSFT]]

Files that you upload/save into companyweb are stored into the WMSDE/SQL
database that Windows SharePoint Services is configured to use. By default,
these databases would be in the c:\program files\microsoft sql
server\mssql$sharepoint\data directory. You should still be able to open
the files from the companyweb, edit them, and then save them back to the
document library. Also, depending on the configuration of the document
library you can enable versioning as well.

--

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

"noname" <anon...@discussions.microsoft.com> wrote in message
news:5B8053C7-DB98-40FF...@microsoft.com...
>I have started using companyweb, and thus uploaded files from our shared
>drive onto companyweb.
>
> Problem is, now that the files are in company web, I can only find them in
> companyweb! Sometimes we need to make changes to these documents as if
> they were regular docs and not strictly companyweb. Where can I look for
> these files. I went to the place I uploaded them from on the server, but
> they have not been updated! So where are my uploaded docs? Are they in
> the server c: drive? My drive, or on the same drive, but hidden?
>
> It is driving me crazy!!!
>
> Please help...

[Jeff L]

You may find this page helpful.

http://www.microsoft.com/resources/documentation/sts/2001/all/proddocs/en-us/admindoc/ows000.mspx

Regards,
Jeff Loucks
Available Technology Ž
Solutions For Professionals Ž
www.availabletechnology.com

"David Copeland [MSFT]" <davi...@online.microsoft.com> wrote in message
news:uETj3IZ...@TK2MSFTNGP10.phx.gbl...

[Jeff L]

They are not in a folder they are in a database.

Read the administrators guide.

"noname" <anon...@discussions.microsoft.com> wrote in message

news:9F595B6A-1332-4E7A...@microsoft.com...
> thanks, i checked that fodler on the server, and it just had a bunch of
data files.
>
> I want the folders and files i see if was to view company web via explorer
and know where they are located.
>
> I dont see any of the files that i was looking for, which consist mainly
of excel documents and word docs.
>
> ----- David Copeland [MSFT] wrote: -----

[David Copeland [MSFT]]

The Excel/Word files etc that you have uploaded are actually now stored as a
Binary Large Object (BLOB) into a field inside of the SQL database. You
won't see those files in a directory on the hard drive, unless there happens
to be another copy of it. Unlike with STS v1.0 where it stored metadata
type information in the database and the files themselves were stored in a
separate directory, Windows SharePoint Services (WSS) actually stores both
the metadata and files/docs into the database itself.

So for example.. if you stored say 5 files into companyweb.. those 5 files,
by default, would now exists insde the sts_servername_1.mdf 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

"noname" <anon...@discussions.microsoft.com> wrote in message

news:9F595B6A-1332-4E7A...@microsoft.com...
> thanks, i checked that fodler on the server, and it just had a bunch of
> data files.
>
> I want the folders and files i see if was to view company web via explorer
> and know where they are located.
>
> I dont see any of the files that i was looking for, which consist mainly
> of excel documents and word docs.
>
> ----- David Copeland [MSFT] wrote: -----
>

[David Copeland [MSFT]]

Correct.. If you make changes to it.. and re-save it back into companyweb..
any other copies you may have in a directory will not reflect the changes.
A couple of the features of using WSS.. one is the versioning feature.. in
that, if it is enabled on the document library, then if you open a file and
make changes and save it back to the document library then you will now have
the new version and the previous version(s).. also, you can enable
check-out/check-in functionality so that users can check out a document, and
while it's checked out other users should not be able to make changes to the
document until it is checked back in.

--

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

"noname" <anon...@discussions.microsoft.com> wrote in message

news:B1FF29DB-58F9-4241...@microsoft.com...
>
> Ok, I'm starting to get the gist of it.
>
> So lets say I do have 5 docs uplaoded to server in that mdf database. The
> only way I could extract 1 of them and make changes to them, is via
> company web, right?

[Jeff L]

You definitely want to consider using SQL Server.

Furthermore I would potentially use Share Portal in an instance like that.

Regards,
Jeff Loucks
Available Technology

Solutions For Professionals
www.availabletechnology.com

"noname" <anon...@discussions.microsoft.com> wrote in message

news:EA474EAE-9782-4176...@microsoft.com...
> Seems like it would be of use to some documents. We were planning on
moving thousands of documents over, but it may be a bit of a risk! I would
hate to lose the original format, escpecially if something was to happen to
company web. I originally thought that you could just point to any file on
the server and it would cater to it.
>
> Its a tough decision, not sure which route is more appropriate..

[James Reather]

Jeff L wrote:
> You definitely want to consider using SQL Server.

Hmmm....

Don't forget that NTFS beats Sharepoint's SQL/MSDE hands down in terms of
I/O performance. If you don't need versioning and/or check-out, then NTFS
shared folders may be the best solution by far. Just because SBS2003 ships
with Companyweb and doesn't have a company shared folder doesn't mean you
can't create one!

Don't forget the "K.I.S.S." approach:
http://www.google.com/search?q=keep+it+simple+stupid

James

[Jeff L]

Sounds like you have tremendous experience with Document Management
Systems...

Especially systems with thousands of documents. Do you manage a Paperless
Environment James?

"James Reather" <james...@reather.com> wrote in message
news:OgSendcQ...@tk2msftngp13.phx.gbl...

[James Reather]

"Jeff L" <newsgroupsremovea...@availabletech.net> wrote in
message news:%23wGEsud...@TK2MSFTNGP11.phx.gbl...

> Sounds like you have tremendous experience with Document Management
> Systems...

Did the original poster say he wanted or needed a Document Management
System? Sounds to me that, like most SBS customers, he "found" the
Sharepoint companyweb, and is wondering whether he can benefit from it.

> Especially systems with thousands of documents.

Just because someone's got (tens of) thousands of documents doesn't mean
that they have (or need) a Paperless Environment. Why do you assume
Sharepoint Portal Server is going to be a good fit for the original poster?

> Do you manage a Paperless Environment James?

<ouch>

No need to get all touchy... lighten up a little...

James

[noname]

Thanks a lot for all the feedback, its much appreciated.

I think I'm gonna use companyweb "shared documents" for
more of the template type and offical documents, and put
an extra link on the corresponding intranet page that
takes them to open up a shared folder on the server drive,
which is where I currently have the documents arranged by
client. I will call that the "work in progress" folder /
link.

That way, the Works In Progress stay where they are, where
the users can make their adjustments - while the actual
original templates, presentations and final drafts go in
the company web "shared documents"

I was basically trying to see in what way could we benefit
from sharepoint companyweb, as I'm sure you've noticed,
I'm not too familiar with it yet! But it looks like that
it will be very useful to some extent.

Cheers.

>.
>

[Jeff L]

James,

Just some legitimate questions on where you are coming from. You blew off
SQL Server with all of its data management capabilities like it was not a
good suggestion to someone considering Sharepoint Services with thousands of
docs.

Either way if you use SQL Server or Sharepoint Portal you extend the
functionality in ways that a flat file system could not offer.

Sorry if my comments came across as sharp.

Jeff Loucks
Available Technology Ž
Solutions For Professionals Ž
www.availabletechnology.com

"James Reather" <james...@reather.com> wrote in message

news:uEBLqoi...@TK2MSFTNGP09.phx.gbl...

[James Reather]

"Jeff L" <newsgroupsremovea...@availabletech.net> wrote in

message news:%2397Fgfl...@tk2msftngp13.phx.gbl...

> Just some legitimate questions on where you are coming from. You blew off
> SQL Server with all of its data management capabilities like it was not a
> good suggestion to someone considering Sharepoint Services with thousands
> of
> docs.

I've got nothing against storing documents in SQL Server, it's just not the
best solution for everyone.

> Either way if you use SQL Server or Sharepoint Portal you extend the
> functionality in ways that a flat file system could not offer.

While you are entirely correct, you *do* lose performance as a result of
moving documents from an vanilla NTFS partition into a SQL database-driven
portal - that's all I was trying to point out.

As in the rest of life, you rarely get something for nothing ;-)

James

[Jeff L]

That depends on your definition of performance.

"James Reather" <james...@reather.com> wrote in message

news:OWvz7plQ...@TK2MSFTNGP12.phx.gbl...