Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
1  
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

2 Answers 2

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.

http://www.ekhichdi.com/e/INCREASE-THE-SAVE-AS-TEMPLATE-SIZE-9.html

share|improve this answer

Your Answer

 
discard

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