Solved

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

Posted on 2014-10-16
2
401 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 500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

717 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