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 am trying to upgrade SharePoint 2007 web application to SharePoint 2010, I am using attach and de-attach method.

Below is the content database information:

  • Database Size: 66 GB
  • Site Collections: 1 Site Collection

I am facing a very strange problem during migration, after running the below command

stsadm.exe -o addcontentdb -url [http://sitename] -databasename [databasename] -databaseserver [databaseserver]

After running for a long time, it got stuck on X percent (not specific number) and it shows “Upgrade In Progress” in the central administration.

I though may be it needs sometime to finish the current action. But after waiting more than 16 hours, the percentage didn't change, the central administration is still showing In Progress and no errors are there in the log. I tried many times to upgrade the database but same problem happens every time.

share|improve this question
What user account are you using to do the upgrade? Make sure it's a farm account. Also what does your ULS logs say? – Mike Mar 7 '13 at 19:12
We had this issue with one of our 100+GBs DBs also but we let it run and it finally finished with success at around 28 hours. – Dave Wise Mar 7 '13 at 19:27
@Mike: I am using the farm account. the ULS logs doesn't say anything because it didn't finish (no failure). – Hesham Amr Mar 7 '13 at 20:50
@Dave: I will try to let it running more time. I am thinking may be it is something related to database transaction log. – Hesham Amr Mar 7 '13 at 20:50

Your Answer


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

Browse other questions tagged or ask your own question.