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,

  • 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, 2011 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, 2011 at 12:21

3 Answers 3


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.


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


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?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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