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

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.
LVL 3
foxpc123Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

macarrillo1Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
foxpc123Author Commented:
Excellent answer - all followed and is working fine now.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SBS

From novice to tech pro — start learning today.