• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1221
  • Last Modified:

SharePoint Foundations 2010

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?
0
wantabe2
Asked:
wantabe2
  • 2
  • 2
1 Solution
 
QPRCommented:
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....
http://social.technet.microsoft.com/Forums/en-US/sharepointsearch/thread/a42be290-9218-4d49-8b69-d79fcce3c9ac/
0
 
martushaProduct managerCommented:
Also you can upgrade your SQL server express to Sql Server 2010 express, as it has 10 GB limitation of DB size :)
0
 
QPRCommented:
You mean SQL Server 2008 R2 express?
0
 
martushaProduct managerCommented:
yes, SQL Server 2008 R2 Express, sorry :)
0
 
wantabe2Author Commented:
The clean up ideas link was what I needed. Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now