SharePoint 2016, Sharepoint 2013, Sharepoint 2010, Windows Server 2012, Sql Server 2012,2014,IIS, Active Directory,User Profile Service, Managed MetaData Service, Search Service, Topology, Web Application, IIS, Site collection, List, Library, PowerShell, office web app, Windows Authentication, NTLM, Kerberos, Saml, ADFS, Active Directory Import, MIM, SharePoint 2016 Central Admin – Upgrade and Migration – Review Database Status – SharePoint

SharePoint 2016 Central Admin – Upgrade and Migration – Review Database Status

When you click on the review database status Link, you will be landed 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 the all the content Databases attached to 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 database attached to the farm. In that report page, you will know what the Database name is, SQL server where it is hosted, Type of the database and also status of the database. This is easy and quickest way to get the list of the databases attached with farm along with their status.

This is 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 required. Something, when you migrate from one version of SharePoint to 2nd version then reviewing the database status page will give you detailed 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 much 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 review the database status and if he sees any issue then can act according. I am only explaining the report and options here not talking about the error & how to fix them.

Keep reading and likening my articles.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *