SharePoint 2016 Central Admin - Upgrade And Migration - Review Database Status

When you click on the "Review Database Status" link, you will land on "Manage Database Upgrade Status" page. This page will give you information about all the databases (content, config, services) attached to SharePoint farm.

Review Database Status page’s direct link - /_admin/DatabaseStatus.aspx

Many times, SharePoint admins want to see all the content Databases attached to a farm, at a single place. We can run a PowerShell command to get the list of all databases attached to farm.

In the SharePoint Central Admin, we have one place where you can see all the databases attached to the farm. In that report page, you will know what the Database name is, where SQL server is hosted, Type of the database and also status of the database. This is the easiest and quickest way to get the list of the databases attached with farm along with their status.

This is a really informative report, especially when you apply the patches and upgrade the farm then this is the report you want to review to make sure all of your databases are up to date and no action is required. Something, when you migrate from one version of SharePoint to a 2nd version then reviewing the database status page will give you details about the dbs.

Let's walk through the information we will see on this page. In this report, there are 4 columns.

  1. SQL Instance
    Name is self-explanatory for this column. This column will tell you the SQL server instances where databases are hosted, if you have multiple SQL servers which are hosting the databases then this column will show the correct name in front of db.

  2. Database
    This is the name of the database, whatever name you used while provisioning the database. i.e. KF-SPConfig, wss_content etc

  3. Type
    This column give us the information about the type of the content database. If the database is content database, then it will list it as content database or if it is configuration database then it will be listed as Config database or if it is any services database i.e. app management service or secure store service it will be listed as App Management Database or Secure Store Service database.

  4. Status
    Last column is about the status of the database, which is very helpful for SharePoint admins. If all the databases are up to date, then this column will say “No action required” but if there is some issues with the database then you will see error information. Here are couple of different status you can see.

    1. No Action Required
    2. Database is in compatibility range and upgrade is recommended
    3. Not responding
    4. Error
    5. Database is too old and upgrade is required
    6. Database is up to date, But some sites are not completely upgraded.

Once SharePoint Administrator reviews the database status and if he sees any issue, then can act accordingly. I am only explaining the report and options here, not talking about the errors & how to fix them.

Keep reading!!!