?
Solved

Can't delete data from Sharepoint 2010 - database full error 80131904

Posted on 2014-10-16
2
Medium Priority
?
418 Views
Last Modified: 2014-11-01
We have an issue with a SharePoint Foundation 2010 (SBS 2011) site which is full (10GB).

So we have copied data from a couple of the folders on the server and stored them locally as these can be archived off the database. However, although I can delete a couple of the files from the site, after a while I hit error 80131904 (which is the database is full).

So I am unable to clear the files out of the recycle bin and also we cannot add files to the database.

I have been able to connected using SQL Management Studio and can shrink the database/files, however, this is by a minute amount and then I can possibly delete one file and then we are back in the same situation.

There must be a better way than this to clear out files from the database - I'd be grateful for ideas and/or assistance.

We will be moving this database to a hosted sharepoint environment, but first we need to be able to clear some of the data from the database itself.
0
Comment
Question by:foxpc123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Accepted Solution

by:
macarrillo1 earned 2000 total points
ID: 40385109
I would recommed the following general process:

Make a backup of the site.
Then export the site out.
Then delete the site and create a new one.
Import the site back in.
If their is a problem you can restore your backup.
0
 
LVL 3

Author Closing Comment

by:foxpc123
ID: 40417032
Excellent answer - all followed and is working fine now.
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

752 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