Share via


Restart a database-attach upgrade or a site collection upgrade to SharePoint 2013

APPLIES TO: yes-img-132013 no-img-162016 no-img-192019 no-img-seSubscription Edition no-img-sopSharePoint in Microsoft 365

In some cases, you might have to restart upgrade to finish a database-attach upgrade from SharePoint 2010 Products to SharePoint 2013. For example: if a template or language pack is missing from the environment, or if you lose the connection to SQL Server, you will have to resolve the issue and then restart upgrade. You might also need to retry or restart a site collection upgrade if it was unable to complete.

Note

One frequent cause of failures during upgrade is that the environment is missing customized features, solutions, or other elements. Be sure that any custom elements that you must have are installed on your front-end web servers before you start the upgrade process. You can use the Test-SPContentDatabase Microsoft PowerShell cmdlet to identify any custom elements that your sites might be using. For more information, see Use a trial upgrade to SharePoint 2013 to find potential issues in the article "Use a trial upgrade to find potential issues."

Restart upgrade for a database by using PowerShell

If the upgrade ran into issues during the database-attach upgrade, you can restart the upgrade process for the database after you have addressed the issue by using a Microsoft PowerShell cmdlet.

To restart upgrade for a database by using PowerShell

  1. Verify that you have the following memberships:
  • securityadmin fixed server role on the SQL Server instance.

  • db_owner fixed database role on all databases that are to be updated.

  • Administrators group on the server on which you are running the PowerShell cmdlets.

    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.

    Note

    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about PowerShell permissions, see Add-SPShellAdmin.

  1. On the Start menu, click All Programs.

  2. Click SharePoint 2013.

  3. Click SharePoint 2013 Management Shell.

  4. At the Microsoft PowerShell command prompt (PS C:\>), type the following command:

Upgrade-SPContentDatabase <Name>

Where:

  • Name is the database name that you want to upgrade.

You can also use the -id parameter and provide the database GUID instead of a database name. You can run the following cmdlet to find the GUID for a content database:

Get-SPContentDatabase -Identity <content_database_name>

For more information, see Upgrade-SPContentDatabase and Get-SPContentDatabase.

Restart upgrade for a site collection

If upgrade ran into issues during a site collection upgrade, you can restart the upgrade process for the site collection after you have addressed the issue. You can use either the Site Settings page or a PowerShell cmdlet to restart upgrade for a site collection.

To restart upgrade for a site collection

  1. Verify that the user account that performs this procedure is a site collection administrator.

  2. On the Site Settings page for the site collection, in the Site Collection Administration section, click Site collection upgrade.

  3. On the Site Collection Upgrade page, click Upgrade this Site Collection.

    This option starts to upgrade your site collection. A box opens to verify that you want to start the process.

  4. Click I'm ready to start the actual upgrade.

    Note

    The site collection health checks are run automatically in repair mode before the upgrade starts. The results from the health checks are included in the upgrade log for the site collection. If there is an error, you must address it before you can continue to upgrade.

    The upgrade starts, and the Upgrade status page for the site collection is displayed. This page automatically updates while the upgrade is in progress and displays information about the process, such as the following:

  • Errors or warnings

  • When the upgrade started

  • Where you can find the upgrade log file

    After the upgrade is complete, the Upgrade status page is displayed in the new user interface with the message, Upgrade Completed Successfully.

  1. Click Let's see the new site to go to the home page.

Farm administrators can restart upgrade by using PowerShell.

To restart upgrade for a site collection by using PowerShell

  1. Verify that you have the following memberships:
  • securityadmin fixed server role on the SQL Server instance.

  • db_owner fixed database role on all databases that are to be updated.

  • Administrators group on the server on which you are running the PowerShell cmdlets.

    An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.

    Note

    If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about PowerShell permissions, see Add-SPShellAdmin.

  1. On the Start menu, click All Programs.

  2. Click SharePoint 2013.

  3. Click SharePoint 2013 Management Shell,.

  4. At the PowerShell command prompt, type the following command:

Upgrade-SPSite <http://site> -VersionUpgrade [-Unthrottled]

Where:

  • <http://site> is the URL for the site collection.

  • Add the option -Unthrottled option to skip the site collection upgrade queue and start the upgrade immediately.

For more information, see Upgrade-SPSite.

See also

Other Resources

Upgrade from SharePoint 2010 to SharePoint 2013