Solved

Sharepoint 2007 to 2010 Upgrade - Failing because of MODULES on the 2007 database

Posted on 2014-07-31
3
111 Views
Last Modified: 2014-09-17
We are trying to upgrade a Sharepoint 2007 installation to Sharepoint 2010...when we upgrade the database, the upgrade is failing because of modules on the 2007 Sharepoint database that do not upgrade correctly.  

We have done a Sharepoint MIGRATION to a separate 2007 server using the same database and THAT worked fine.  

The upgrade reports all of the modules that caused the update failure in the error log, has anyone ever dealt with this before?  How can I  get this upgrade to continue and skip the errors?  Or can I pull the modules out before migration using any particular method?  It seems that the database upgrade STOPS when it hits these items, because the database is not in a functional state after the migration runs.

Any help is appreciated.  We have had Microsoft PSS on the issue working with us for a few weeks and the Sharepoint team and SQL team could not resolve this...

Thanks!
0
Comment
Question by:jkeegan123
  • 2
3 Comments
 
LVL 8

Expert Comment

by:Jayaraja Jayaraman
Comment Utility
did you run the pre-upgrade check before you actually migrated? wat are the issues you find?
0
 
LVL 5

Accepted Solution

by:
jkeegan123 earned 0 total points
Comment Utility
This issue was resolved by doing a full dbcc check on the associated sql database before attempting the upgrade. This was an enormous task due to the size of the database (200gb), and the check took about 20 hours to complete, however once completed we retried the database migration and were successful.

Note that the upgrade log did not indicate at any point that there was corruption in the database  but database maintenance was the only item that we had not completed. I did it more for the size of the database than anything else, thinking that in a 200gb database there is sure to be some table or logical corruption. The check resulted In a larger 250gb database, but everything was consistent and the dbcc check did not result in any data loss.
0
 
LVL 5

Author Closing Comment

by:jkeegan123
Comment Utility
There was no other solution offered and this is the solution that fixed the issue.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now