Verify database upgrades in SharePoint 2013

Verify upgrade status for databases

You can use the following methods to verify upgrade:

• Use the Upgrade Status page in Central Administration
  This page lists all farm, service, or content database upgrades and their statuses. This includes a count of errors or warnings.
• Review the log files to look for errors or warnings
  If upgrade was not successfully completed, you can view the log files to find the issues, address them, and then restart the upgrade process.

Review the log files for database attach upgrade

To verify that upgrade has succeeded, you can review the following log and error files:

• The upgrade log file and the upgrade error log file.
  Review the upgrade log file and the upgrade error log file (generated when you run the upgrade). The upgrade log file and the upgrade error log file are located at %COMMONPROGRAMFILES%\Microsoft Shared\Web server extensions\15\LOGS. The logs are named in the following format: Upgrade-YYYYMMDD-HHMMSS-SSS.log, where YYYYMMDD is the date and HHMMSS-SSS is the time (hours in 24-hour clock format, minutes, seconds, and milliseconds). The upgrade error log file combines all errors and warnings in a shorter file and is named Upgrade-YYYYMMDD-HHMMSS-SSS-error.log.

Check upgrade status for databases

The Upgrade Status page lists the upgrade sessions and gives details about the status of each session — whether it succeeded or failed, and how many errors or warnings occurred for each server. The Upgrade Status page also includes information about the log and error files for the upgrade process and suggests remedies for issues that might have occurred.

To view upgrade status in SharePoint Central Administration

1. Verify that you have the following administrative credentials:
   • To use SharePoint Central Administration, you must be a member of the Farm Administrators group.
2. On the Central Administration home page, in the Upgrade and Migration section, click Check upgrade status.

Validate the upgraded environment

After you determine whether upgrade was completed successfully, validate your environment. Review the following items:

• Service applications
  • Are they configured correctly?
  • Are the service application proxies configured the way that we want?
  • Do we have to create new connections between farms?
• Site collections
  • Are sites that were not upgraded working as expected in 2010 mode?
  • Are all features associated with the sites working?
• Search
  • Run a crawl, and review the log files.
  • Run search queries, and verify that the queries work as expected and provide appropriate results. Twenty-four hours later, view the query reports and look for issues.
  • Search for people and profiles.
  • Check any Search customizations to make sure that they work as expected.