Data base is Up to date but some sites are not completely upgraded

Data base is Up to date but some sites are not completely upgraded

                      Or

Product\patch installation or server upgrade required

                      

Issue: After Mount-SpcontentDatabase,having Database is up to date, but some sites are not completely upgraded. On /_admin/DatabaseStatus.aspx. When I click on the /_admin/UpgradeStatus.aspx it shows me the status Succeeded

Resolution: First of all, to identify what site collection doesn't got upgraded.

         Run: stsadm.exe -o localupgradestatus > upgradestatus.txt

or

PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures  (Run from one of the WFE server)

In below as you see, there no site collection that need upgrade.
If you have any, you can identify them by searching by word "Needs upgrade" in this file.                   

Secondly, run the command in the Power Shell:

For resuming the upgrade, you’ll need the ID for the database :

Get-SPContentDatabase -Identity <your content database name>

When you got the GUID for the database you can then resume the upgrade

         upgrade-spcontentdatabase -id <database GUID>

Finally, check the upgrade status by running stsadm again:

   stsadm.exe -o localupgradestatus > upgradestatus.txt

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!