Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

The mdf of my WSS Log DB has become too big and I need to reduce the size. There appears to be a lot of articles on the net about shrinking the db, which will reduce the ldf size. My problem though is the MDF is too big and I need to reduce that.

I am using MOSS 2010.

share|improve this question
Do you mean too big in the sense that it has a lot of free space or do you have a large amount of content in it that you want to split across separate content databases? – Chris W Jul 7 '10 at 8:14

You can choose to shrink the DB's data files. Just choose the Files->Data option when you choose to shrink instead of Database option.

share|improve this answer

You can delete some site collection that is not in used, or you can Trim the audit logging in Sharepoint. The audit logginf takes lot of disk space.

Also you can try to create multiple content database and keep the existing database limit to as achived.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.