I am trying to upgrade sp2010 Content Db to Sp2013. For that I took a backup of sp2010 content db of size ( 15GB) then I executed Mount-SPContentDatabase command. Upgrade is now stuck in 4.62% where it is running step 20 of 130. In Sp Logs It is running following step:

InsertAllUserDataSparseDefaultRowOrdinal (15.0.20.1)    ajywf   DEBUG   Begin Upgrade() a0e125e2-246b-449b-9852-eea9d0f8884f

How do I make it go faster, I has been stuck in that stage for 9 hours now.

Here are my System Specs:

Sp2013 Farm: OS: Windows Server 2012

SQl : Microsoft SQL Server 2012 - 11.0.5058.0 (X64)   May 14 2014 18:34:29   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1  (Build 7601: Service Pack 1) (Hypervisor)

Assigned Memory: 8Gb

Space left in Data Drive: 98 GB

Config DB version: 15.0.4719.1000

Hi,

As I understand, it is stuck at 4.62% when upgrading to SharePoint 2013.

When the upgrade is stuck, you could run the PowerShell command below. For more detailed information, you could refer to the article below.

Upgrade-SPSite http://yourserver VersionUpgrade 3.95% : SPSite Url=http://yourserver

The article below is about migrating SharePoint 2010 to SharePoint 2013.

https://adilmca.wordpress.com/2014/05/21/migrate-sharepoint-2010-to-sharepoint-2013/

More references:

The article below is about SharePoint: Manually upgrade Service Application database.

http://blog.jussipalo.com/2014/01/sharepoint-manually-upgrade-service.html

There is a similar case:

https://social.technet.microsoft.com/Forums/office/en-US/6fb03b9c-8f20-4b19-a08c-aee3464591f3/upgrading-sp2010-large-database-hangs

Best regards,

Sara Fan

Hello ,

when you are migrating you should first check the data you are mounting

use below command to test the database .

Test-SPContentDatabase -Name WSS_Content_PERApplication -WebApplication http://vsp2013dev01dsy:3423.

and second thing you should check have you created the site in the classic mode authentication because if you have created the site in the claim based authentication it will stuck .

But the above command will check all the features you requires

What Does VersionUpgrade 3.95% mean?

I did run Test-SpContentDatabase in Sp2010 machine before upgrade, I had some errors but non of them were upgrade blockers. Then I tried to create a brand new site in sp2013 with classic auth and tried to mount db again with -NoB2BUpgrade now its stuck at 15.68% but under same step step 20 of 130. In Splogs it is still upgrading

08/25/2015 12:04:32.24	powershell (0x417C)	0x07EC	SharePoint Foundation Upgrade	SPUpgradeSession	ajxn1	DEBUG	UPGRADE PROGRESS: current object = [SPContentDatabase Name=WSS_Content_SpHub], current sequence = [SPContentDatabaseSequence], action 20 out of total 130	95ac6685-859e-426f-bd24-0333c1e58d08
08/25/2015 12:04:32.24	powershell (0x417C)	0x07EC	SharePoint Foundation Upgrade	SPUpgradeSession	ajxn2	DEBUG	UPGRADE PERCENTAGE: 15.38461538% done, Total Elapsed Time 00:02:19.9785173.	95ac6685-859e-426f-bd24-0333c1e58d08
08/25/2015 12:04:32.35	powershell (0x417C)	0x07EC	SharePoint Foundation Upgrade	InsertAllUserDataSparseDefaultRowOrdinal (15.0.20.1)	ajywc	DEBUG	Begin Initialize()	95ac6685-859e-426f-bd24-0333c1e58d08
08/25/2015 12:04:32.35	powershell (0x417C)	0x07EC	SharePoint Foundation Upgrade	InsertAllUserDataSparseDefaultRowOrdinal (15.0.20.1)	ajywd	DEBUG	End Initialize()	95ac6685-859e-426f-bd24-0333c1e58d08
08/25/2015 12:04:32.35	powershell (0x417C)	0x07EC	SharePoint Foundation Upgrade	InsertAllUserDataSparseDefaultRowOrdinal (15.0.20.1)	ajywe	INFO	Copy columns in the default row ordinal into AllUserDataSparse.	95ac6685-859e-426f-bd24-0333c1e58d08
08/25/2015 12:04:32.35	powershell (0x417C)	0x07EC	SharePoint Foundation Upgrade	InsertAllUserDataSparseDefaultRowOrdinal (15.0.20.1)	ajywf	DEBUG	Begin Upgrade()	95ac6685-859e-426f-bd24-0333c1e58d08

Check the below given informative resources that might helps you to get in more details and lets you to get this job done.

Check this article which explains how plan to upgrade site collections to SharePoint 2013

Also have a look on this step by step guide on upgrading a SharePoint 2010 site to a SharePoint 2013.

As a workaround create a site collection in SharePoint 2013, detach the newly created content database and then attach the 2010 content database to the site collection. SharePoint 2013 will upgrade it for you.

The process is explained here http://www.orcsweb.com/blog/cory-granata/how-to-upgrade-sharepoint-2010-to-sharepoint-2013-using-database-attach/

Moreover, If you wish you may also try this automated solution which lets you to migrate from SharePoint 2010 to SharePoint 2013 without any interruption.

Hope it helps you!