SharePoint MDF size doesnt match site content RRS feed

  • Question

  • Hi I have a Windows Sharepoint Services 3.0 running with MS SQL 2005. I have a problem in that the DB size is 270GB. Sharepoint Usage Summary says the content size used is 76GB. I also downloaded a utility to show me the invdivual size of the sites and when totaled up, they amount to 76GB. The name of the utility is SPUsedSpaceInformation. When going to properties on the database itself, it shows the DB as 330GB with 60GB free space.

    My questions are:

    1. Does sharepoint usage summary or even this tool that I downloaded show all the space sharpeoint content is using

    2. How can I find the missing 194B and remove it?


    Thanks in Advanced

    Tuesday, February 15, 2011 10:24 AM

All replies

  • Hi,

    are you refering only MDF files or whole Database ?

    If its whole database then it also contains LDF files as well.


    Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    Tuesday, February 15, 2011 12:19 PM
  • The following items will not be counted in your site use space info or the usage summary.

    • Recycle bin
    • Audit trail
    • Versioning (Not 100% sure but I think this is also not counted)
    • Usage summary

    So if you have a lot of data in any of these tables, they will account for the additional sizes.


    Tuesday, February 15, 2011 1:44 PM
  • Ive cleared recylce bin


    How can I find out if versioning is counted? I'm pretty sure is it counted because If I use explorer view, I can see all the sub sites and their document libraries. These libraries only show the latest files. If I check the size of them there, it shows 10GB in total. Im guessing the 76GB then includes all versioning.


    The Audit trail you are referrgin to, is that version control or is that a seperate thing?

    Tuesday, February 15, 2011 2:11 PM
  • Im refering to the MDF because I can truncate the LDF without any problems
    Tuesday, February 15, 2011 2:11 PM
  • I'm Not sure if this might help... but i tried to copy the DB (MDF) file to another location and after about 30%, I get a read error from the file. Is it possible the MDF file is damaged? If so, how can I repair it?


    The other option I have is to move my site collection to another DB, whats the process for this? I know how to export using stsadm but it doesnt export all versions of documents. Im looking for something that can then transfer my site collection plus all sub sites plus all versions of documents etc



    Wednesday, February 16, 2011 6:40 AM
  • Hi,

    Suggest to read the link below, it contains information that will help you.


    Make sure u have a backup before proceeding these steps and test this out in a non production environment.



    Wednesday, February 16, 2011 8:14 AM
  • By Audit Trail I was referring to the Site Collection Audit settings that is available under Site Actions --> Site collection audit settings --> Configure Audit Settings.

    This has the potential to grow very large over a brief period of time and is not counted in the report.

    The other thing is the Usage analysis processing data which is not counted.


    Wednesday, February 16, 2011 12:35 PM
  • I dont actually have that menu  or setting.... under my Site actions, there is just Create, Edit page and Site settings.

    After trying a few things last night, I found the following errors:


    When copying the MDF to another location, it gives a read error after 20%. Could there be a problem with the MDF or is this because I am trying to copy a 330GB file?

    Thursday, February 17, 2011 6:26 AM
  • Hi Hazardr,

    Content database store all site content, site documents, such as files in document libraries, list data; Web Part properties; and user names and rights. But you can also find that are some other table in the content database, like Event Log. And it would also do some duplicate for a site collection. So it would larger than a Site Collection itself.

    You should better not delete LDF file, otherwise part of data would get lose occasionally.

    Please follow this reference to move database. http://technet.microsoft.com/en-us/library/cc512725(office.12).aspx
    And please don’t move the database by copying MDF file.

    Thanks & Regards,
    Emir Liu

    • Marked as answer by David HM Wednesday, February 23, 2011 4:46 AM
    • Unmarked as answer by Hazardr Monday, March 7, 2011 9:36 AM
    Thursday, February 17, 2011 9:22 AM
  • I decided to backup my sharepoint and restore it to a test server. I then moved the site collection to another DB and the DB size was still the same (312GB). In sharepoint, it reported usage as being 90GB.


    I then started deleting all sites and workspaces and coument libraries. I now have no sites besides the main site with absolutely nothing in it and the DB size only got reduced by 100GB... its not sitting on 220GB... where is all this space coming from? I have checked both normal and Admin recylce bin and there is nothing.


    Any ideas as to where the space came from?

    Monday, March 7, 2011 9:51 AM
  • > I decided to backup my sharepoint and restore it to a test server (etc.)

    This post is identical to one you made at the same time as a new thread.

    The rules are simple

    1. NEVER post the same post twice.

    2. It is your choice as to where you post to

    EITHER: make a new post - i.e. start a new thread

    OR: make a reply to an existing thread.

    Note: Use the EITHER case if the existing thread is a) closed or b) old or c) your post to it is a question that is new to the thread.

    Here your current thread is current and your post to it is still on the subject of size which started the thread so I left that copy and deleted the new thread.

    In future please remember that duplicate threads (= here the same question in different threads) are a waste of time for all forum members and so please don't create them.

    Moderator pre-2010 forums


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Monday, March 7, 2011 10:12 AM
  • apologies, I created the new one first and then reliased I could actually just continue this one. Will keep the above in mind


    Monday, March 7, 2011 10:19 AM
  • Thanks. I already (as I wrote) deleted the duplicate.

    I'll leave my post here as information to others reading this thread. You are not the first person (and won't be the last) who has done this!


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Monday, March 7, 2011 10:24 AM
  • no one?
    Wednesday, March 9, 2011 11:38 AM