SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've got a customer looking to consolidate 2 WSS 3.0 servers onto one. Usually I deal with SharePoint standard edition and can get at the databases with SQL Management studio etc. I should be able to do that for this site as well. I am just puzzling out how to achive this.

Would it be a case of having to create another site collection and attaching the database from the other server or attempt some kind of export / import operation on it. I believe the DBs are under 4GB since they were setup using the wizard.

Any suggestions are much appreciated. I would suggest they go to SharePoint Foundation but having some licencing issues for Server 2008 R2.

share|improve this question
up vote 0 down vote accepted

I'll answer this myself:

Backup database from Windows Internal Database using SQL server management studio Express and connect to the WID instance using named pipes:


Using SQL management studio backup the content databases in question and copy those to the target WSS 3.0 server.

Prep the target WSS 3.0 server in this case I was using a full version of SQL Server 2005. Restore databases from the copied server.

Create new web application with no site collection Remove content DB from newly created web application Add content DB from original server to the newly created web application and there you have it 1 site collection was showing and working as the original did as it was vanilla without any solutions.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.