Hi every one. My SharePoint site collection database is growing too fast. What can the reason be? How can i find out the reason and the way to solve it?? Thanks in advanced

Hi, Content DB is not for Site Collection level this is for one WebApplication. All the Site Collections under that Web Application managed in that Content DB. You check whther the DB you are growing is the Db for which WebApplication it belongs to. Content Db grows if you are storing so many things in to that i.e Documents,etc in Document Library , Lists. etc of huge size. Along with so much customization you made in your sharepoint site with Sharepoint designer. Hope this will help you. Thanks Shrivallabh Kulkarni

I know. I just want to know why is it growing too fast, 1GB per 10 days actualy, with less than 100 personnels in the company and with only one site collection on that web application, since 3 or 4 month ago.

document versioning may be one of the issue if you have large document library and doing some minor change frequently Manish Sati

Hi, What are the Documents presents in the Sites. What are the and whether versioning is there. And how many user using this Site.Thanks Shrivallabh Kulkarni

You CAN check what's in a sitecol, althought weirdly, you have to setup a disk quota for the sitecol to see the option. go to settings --> site collection disk usage (usual culprits are the bin, the versions, and the ceo's powerpoint 2003's for the investors) additionally, if you speak about SQL, are you talking about pure data (MDF), or total physical space (MDF+LDF)? i've lost the count of customers i met who didnt backup anything and ended up with a disk full of transaction logs (.LDF)

HI... Also pay att. to Audit settings... they don't clean up over time... they just stay in the Auditdata table.... stsadm -trimauditlog is the keyword for that.. :-) /dan

Thank you every body. Dear Emanual, I'm talking about the MDF files. And i'm backing up the entire databases on the it's server and on the tape. Dear Shrivallabh, Yes we are using the versioning. There are less than 100 personnels in the company. There are different types of librariyes in use like, form library, document library. And you know what, i'm not sure about the big files stored in that libraries. But i know our SharePoint doesn't attach files that are bigger than 50 MB. I know i need to find big files storing in the SharePoint. Is there any way to do that? Dear Dan, Thanks for the attention. I'll take a look at it right now Dear Manish, Thank you too. I'll check it. By the way. Is there any way to find the big files in SharePoint?

Hi, You can upload files whose size more than 50MB for this http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2008/06/30/changing-the-maximum-file-upload-size-in-sharepoint.aspx and for downloading the file you go through this best practice http://technet.microsoft.com/en-us/library/cc262061(office.12).aspx Hope this willl helpful to you.Thanks Shrivallabh Kulkarni

Dear Shrivallabh. Thanks, but these links are not about my problem.

Hello Amir, I feel you. Similar to yours, I have a Sharepoint site collection (one of many) that is still undergoing development and the only files that exist there a testing Word documents (templates) without content but because of the many customizations it currently is at 1GB; this site hasn't even gone live yet! In your case, I would like to ask if you have a video library in your Sharepoint. You know how big those files can be. However, if you don't have a video library it is possible that your users are uploading media files into certain document libraries, especially those that have no content type defined! Remember also that certain lists have the "attach" option, verify that they are not using it for media files as well. If you have picture libraries, that is another culprit, especially in this day of mega-pixel cameras, your users may have been uploading such high quality pictures in the libraries. About a method to know the largest sized files in your farm, there are quite a bit of methods if you google around a bit, I found this, I couldn't verify this if it works (am in a restaurant),I'll check it out as soon as I can, give us feedback if it's helpful or not. select [filename], sum(CAST((CAST(CAST(filesize as decimal(38,2))/1024 As decimal(38,2))/1024) AS Decimal(38,2))) AS 'Size in MB' from ( select dirname + '/' + leafname as [filename], size as filesize, siteid, webid, ExtensionForFile from alldocs union select d.dirname + '/' + d.leafname as [filename], v.size as filesize, d.siteid, d.webid, ExtensionForFile from alldocs d inner join alldocversions v on d.siteid = v.siteid and d.id = v.id ) as results inner join webs s on s.siteid = results.siteid and s.id = results.webid where (filesize is not null and filesize > 0) and ExtensionForFile not like '%aspx%' -- Not Include Certian File Types group by [Filename] order by 2 descYou've only got one life; help as many people as you can, and enjoy it while it lasts.

One way to find the total size of a library, or site, is to go to a library, click Actions, Open in Windows Explorer. Then Click the Folders button in the toolbar. In the folder tree, right-click the library and click Properties. You should now see a file count and size. To find your biggest files in a library: Create a new view (Standard view) Add the File Size column In the Sorting section sort by File Size and Descending In the Folders section select "Show all items without folders" In the Item Limit section enter a value such as 100 to see the 100 largest files. (Note, these sizes, do not include versions of the files. You may want to add the Version column to at least see if the file has versions) Also, go the top level site in the Site Collection and review the recycle bin to see how much deleted content is in your database. Mike Smith TechTrainingNotes.blogspot.com

Another thought that I don't think has been mentioned yet: The size of your content database(s) also depends on the recovery model being used. You might want to check out the simple recovery model - note that this is only acceptable where loss of recent changes is acceptable (i.e. changes since your last backup). This is due to the fact that the simple recovery model does not support log backups - and hence uses far less disk space and simplifies backup / recovery. By default, SharePoint content databases created via central administration are set to use the full recovery model.Benjamin Athawes Twitter SharePoint Blog

Hi Amir, I checked up on the SQL statement I gave you and it works fine, but you have to be in the right SharePoint database(s). The problem is you will have to do that many times and the results could be really lengthy...it's just all round troublesome. Hence, I will suggest you follow Mike's solution. It's neat and you don't want to be messing around your databases except of course you absolutely know what you are doing. For now, you at least have more than one way to skin this cat. Benjamin's suggestion is good but he has informed you about the danger of that, it's risky for a production environment. Cheers! You've only got one life; help as many people as you can, and enjoy it while it lasts.