Solved

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

Posted on 2014-07-31
3
113 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
ID: 40239025
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
ID: 40319286
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
ID: 40327533
There was no other solution offered and this is the solution that fixed the issue.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
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…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

813 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

18 Experts available now in Live!

Get 1:1 Help Now