SharePoint Foundations 2010

Posted on 2012-08-31
Last Modified: 2012-09-04
I have been getting the error in my event log #1827 because my database is exceeding the 4096MB size limit for the free version of SharePoint 2010 Foundatins. I have found in the DB the MSSCrawlURL & it's size is enormous. It is almost 3GB. Can I safely delete the data in this table without causing any issues with the SharePoint? I've also discovered several other DBO's that have rather alrge size such as MSSDeleteList, MSSCrawlDeletedURL, MSSCrawlURLLog, etc....Can I delete any of the data in these tables to regain some space?
Question by:wantabe2
    LVL 29

    Accepted Solution

    The quick answer is yes you can, the unfortunate part is that you shouldn't work on sharepoint databases directly as this is unsupported by microsoft... so I'll leave you to decide which road to take :)

    It is your free version of SQL Server that has the limitations not sharepoint foundation.

    For some clean up ideas....
    LVL 6

    Expert Comment

    Also you can upgrade your SQL server express to Sql Server 2010 express, as it has 10 GB limitation of DB size :)
    LVL 29

    Expert Comment

    You mean SQL Server 2008 R2 express?
    LVL 6

    Expert Comment

    yes, SQL Server 2008 R2 Express, sorry :)
    LVL 15

    Author Closing Comment

    The clean up ideas link was what I needed. Thanks

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
    Hello, In my precious Article  ( saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now