Hi, i'm having a content database issue. I am not a DBA guy by the way, so i'm not sure if it's a SQL problem or Sharepoint problem. Right now my Intranet Content database is around 208 GB, and the log file is 141 GB!!! I type the command: stsadm -o enumsites -url https://intranetsite and i got: <Sites Count="1"> <Site Url=https://intranetrsite Owner="domain\*****" SecondaryOwner="domain\******" ContentDatabase="intranetsite_Content" StorageUsedMB="9869.6" StorageWarningMB="0" StorageMaxMB="0" /> </Sites> So if i understand, my site collection uses only 10GB out of 208 GB!!! Can anyone tell me what's wrong ? Thank you LP

Is the problem the DB in SQL is larger than you expected? In SQL you can right click the DB, choose properties and look at the size of the db (is it set to auto grow and auto shrink?) The log file is a portion of the DB size depending on the growth size setting under properties, you can look at the following link to get an idea of how to defrag and shrink your db's. PLEASE BACKUP Everything in SQL before doing the following... I would also backup SharePoint using the GUI or STSADM. http://kbalertz.com/943345/defragment-Windows-SharePoint-Services-databases-SharePoint-Server-databases.aspxKris Wagner, MVP, MCITP, MCTS Twitter @sharepointkris Blog: http://www.sharepointkris.com/blog

Is the problem the DB in SQL is larger than you expected? In SQL you can right click the DB, choose properties and look at the size of the db (is it set to auto grow and auto shrink?) The log file is a portion of the DB size depending on the growth size setting under properties, you can look at the following link to get an idea of how to defrag and shrink your db's. PLEASE BACKUP Everything in SQL before doing the following... I would also backup SharePoint using the GUI or STSADM. http://kbalertz.com/943345/defragment-Windows-SharePoint-Services-databases-SharePoint-Server-databases.aspxKris Wagner, MVP, MCITP, MCTS Twitter @sharepointkris Blog: http://www.sharepointkris.com/blog

Is the problem the DB in SQL is larger than you expected? In SQL you can right click the DB, choose properties and look at the size of the db (is it set to auto grow and auto shrink?) The log file is a portion of the DB size depending on the growth size setting under properties, you can look at the following link to get an idea of how to defrag and shrink your db's. PLEASE BACKUP Everything in SQL before doing the following... I would also backup SharePoint using the GUI or STSADM. http://kbalertz.com/943345/defragment-Windows-SharePoint-Services-databases-SharePoint-Server-databases.aspxKris Wagner, MVP, MCITP, MCTS Twitter @sharepointkris Blog: http://www.sharepointkris.com/blog

Hi LP, Content databases store all site content: site documents, such as files in document libraries, list data; Web Part properties; and user names and rights, Event Log and some other data. A content database can be associated with many site collections. Seems it would also do some duplicate sites for a site collection. So it would always much larger than a Site Collection database.Best regards. Emir

Hi LP, Content databases store all site content: site documents, such as files in document libraries, list data; Web Part properties; and user names and rights, Event Log and some other data. A content database can be associated with many site collections. Seems it would also do some duplicate sites for a site collection. So it would always much larger than a Site Collection database.Best regards. Emir

Hi, Thank you all for your reply. So you guys are saying that it's normal that i see: StorageUsedMB="9869.6" (around 10Gig), but my content database has almost 300 GB? I only have one site collection. Emir: I know that the content database contains all files etc, but all this should be in my StorageUsedMB="9869.6" ? I think 10GB is OK for what we have in our Intranet. But i was just wondering why the database would be that big if i only use 10 GB? Is it because i don't backup my SQL database, so it just grows until i do a backup? When i'll do a backup/shrink/truncate what ever my DBA needs to do, that database will go back to around 10GB? Thank you LP

It's possible that you have allocated 200+ gigs for the database. Even if it only has 10Gb of content, it still reserves the remaining space, but is just "empty". This is often done to improve performance as allocating new space can be an expensive operation. If that's the case, 200 Gb is excessive as the maximum recommended size for a content database is 100Gb. You could try shrinking the database and log file to release unused space and free up disk resources to the OS. To do this, take a FULL backup of the database and log file, then follow the instructions in the following article to shrink the files. http://msdn.microsoft.com/en-us/library/ms190488.aspx I've also heard of issues where the information provided by the stsadm -o enumsites command is inaccurate or out of date. Here's an article on how to force a refresh of this data: http://stsadm.blogspot.com/2009/01/recalculating-usage-statistics-via.html Wade Hunter MCP/MCTS - WSS 3.0, MOSS 2007, SharePoint 2010