We help IT Professionals succeed at work.
Get Started

How to clean out the SharePoint "Content_DB" of all User Content

Last Modified: 2012-06-22
I have a particular interest in creating an Entire SharePoint structure outside of the Production Environment i have.  I need to build a DEV & TEST environment.  Now, the problem that i am faced with is Hardware resources.  They are very little compared to the Production environment and well, I need to create these Environments.  

The ideal Solution would be to create the TEST systems and duplicate the PRD systems then copy the databases over.  With the limited amount of Hard Disk space, I will need to figure out a way or purchase a tool that will allow me to clean out the Content_DB for the Sites in question.  What i would like to be left with is an entire TEST envrionment that is exaclty like PRD, but minus the user content, basically leaving just the site heiarchy.  Now Microsoft decided to include the User Content and the SharePoint Site Content (Heiarchy) in the same exact "Content_DB" database.  I have created a few SQL scripts that filters out basic SharePoint files from the user content, but this is not 100% clean as some things are still left around.  This does not provide me with a Optimal TEST environment, as it is not 100% clean.  I did get the scripts pretty darn close and exact to cleanout the files.  But we need a better solution.  Now I am hoping that someone else has been in this same predictament and will have the solution that I need or something close to it.  

Any help would be great as I have searched as much as I could.  I am hoping that someone else had better luck at finding this answer.

I do know that the PRD & TEST systems should be aligned 100% exactly identical, however money does play into this decision, it is not an option to spend any money on hardware, but hopefully the cost of a tool would be lower and make this a reality.
Watch Question
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE