ghostnguyen

Hi,

I have upload 2GBs e-books to Library in Office SharePoint Portal 2007 (OSPP2007). I checked the C drive increase usage disk to 2Gbs also. Howver, I can not find the location of those e-books. Neither in SQL sever (database foder size is 900MBs) nor in IIS.

Next step, I tried to upload another 500MBs and I checked and saw that the "Windows" folder incresed the size.

My question are:

1. Where the OSPP2007 stores files

2. How can I move the those files to D drive (My C driver is running out of disk space)

MA.



Re: SharePoint - Setup, Upgrade, Administration and Operation Where the libraries store files?

sondergaard

Hi there,

SharePoints stores all uploaded files inside the SQL Server database. This is why you see the decrease in available space on the hard drive, but you cannot locate the actual files.






Re: SharePoint - Setup, Upgrade, Administration and Operation Where the libraries store files?

sondergaard

Before deciding on perhaps moving the database to a bigger drive you could check if the log files are taking up a lot of space. If that's the case you should move them and point SharePoint to the new location (via Central Administration).






Re: SharePoint - Setup, Upgrade, Administration and Operation Where the libraries store files?

ghostnguyen

Hi,

I guess the SharePoint store file in DB so.

However, as I said, After I upload 150MB, the Windows folder in C drive expand the size 150MB. NOT the Program Files folder which contains (Microsoft SQL Server folder). The DB files still the same .

In addtion, I use SQLExpress, the db files still stored in Microsoft SQL Server folder. So I dont think there are difference between SQL 2005 versions.

Further more, when I backup the web application (I setup only 1 web application), the folder backup is 5.5GBs, the same as size of all uploaded e-books.

MA





Re: SharePoint - Setup, Upgrade, Administration and Operation Where the libraries store files?

Jukka Paajanen - MSFT

Hi,

The databases come in a variety of shapes and locations depending on how you installed. Based on your description here's what may have happened:

You installed WSS standalone (either leaving your system at WSS or later upgrading to MOSS standalone). This installs WYukon, aka Windows Internal Database, which in turn stores its databases under the %windir% by default. If the content db of your web app is in WID, which it would be by default in this config, seeing %windir% grow when uploading a file makes sense.

Given you see SQL in the Program files, you have most likely also installed SQL Express or full SQL. These store the dbs under the Program files by default.

The different SQL editions do have different behavior and definitely different limitations.

JP





Re: SharePoint - Setup, Upgrade, Administration and Operation Where the libraries store files?

ghostnguyen

Hi,

So, there is any document that guide to config SharePoint Server 2007 using SQL Server, rather than WID

MA.





Re: SharePoint - Setup, Upgrade, Administration and Operation Where the libraries store files?

Jukka Paajanen - MSFT

To use full SQL, install in the advanced mode in farm mode (either WFE or complete, in most cases for each farm you will need at least one complete). The basic/standalone install will use WID and/or SQL express.

The farm install guides will provide you with more details.

JP