Solved

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

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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
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…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

758 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

13 Experts available now in Live!

Get 1:1 Help Now