SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

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 have two server farms, Server farm 1 and Server farm 2. Server farm 2 runs SharePoint 2010 Enterprise with SQL Server 2008 R2 Enterprise and Server 1 runs SharePoint 2010 Enterprise with SQL Server 2008 R2 - Express with Advanced Services. I created a backup of my content database of web application running on farm 1 and restored it to sql on server farm 2. I then created a new web application on farm 2 and attached my content db.

Now after I added content db to my new application on farm 2, it shows no site collection and when I try to visit the url I get page doesn't exist error message.

Am I doing anything wrong?

Kind Regards,

share|improve this question
Try using stsadm -o enumsites to check which sites are listed in the specific content database. What method did you use to attach the content db? – Jasper Dec 14 '11 at 10:58
Thanks for your response Jasper. I used STSADM.exe -o addContentdb -url mysite2:80 -DatabaseName WSS_Content_80 Any ideas? – Sepaka Dec 14 '11 at 12:21

I found the answer. The reason is because the version numbers for my FARM 1 SQL DB is different from the one on FARM 2.

I upgraded both servers to the same built number and everything worked fine.

Thanks to everyone that replied.

share|improve this answer

The reasons could be :

The SPTimer job stuck - reset the timers using stsadm execadmsvcjobs command. Cache.ini reset - Not sure about what this file is but following links give some info.

Hope this helps

share|improve this answer

This behaviour is usually seen when you try to attach a copy of a content database to the same farm, and occurs because the GUIDs are the same. Is it possible that your content db on farm 1 was originally migrated from farm 2?

share|improve this answer
Not possible. Thank you – Sepaka Dec 19 '11 at 7:00

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.