24 July, 2013

The content databases in this cluster are full. You cannot add more web sites until you change the content database web site capacity settings or add more content databases

SharePoint capacity planning plays a very vital role with respect to any farm, whether it’s a small farm, medium farm or large farm. Today I am going to share some details and troubleshooting steps regarding one issue that I faced recently.

Problem Description: we have received the following error message while creating the site collection.

Error Message: The content databases in this cluster are full. You cannot add more web sites until you change the content database web site capacity settings or add more content databases.
Troubleshoot issues with Microsoft SharePoint Foundation.
Troubleshooting done: From the above error message, 2 points comes into the picture i.e. database size and number of site collections exist in a single database.

-Based on analysis, we found out that total site collections exist are 100 and size of the database was 67GB.

-checked the managed databases section in central administration with respect to that web application under which we are trying to create a site collection. We found out that somebody has changed the maximum site collection limit to 100 and that’s why we were facing that error message.

Resolution:
Please refer the following steps to get rid of this error message:
-Central administration
-Application management
-manage databases
-select the appropriate web application from the top
-change the maximum site collection limit to 15000 and warning set to 9000.

That’s it. After this we are able to create site collections without any issues.

If you have any queries/issues regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you. 

3 comments:

  1. You should be willing to buy-in for 20 timеs thе table minimum.
    Gaming apρlications are κnown to oсcupу quite a huge chunκ
    of уour ranԁоm аccess memory (memory uѕed as pгogram ωorkspace).
    When this happens, the online caѕino players thinκ and feеl
    that the game iѕ in faсt riggeԁ.


    Alѕo visit my website spilleautomater

    ReplyDelete
  2. Hi Amol,

    Nice post,thanks for sharing this information. looking forward for more posts like this.

    ReplyDelete
  3. nicely written! Thanks Amol.

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.