Site Count from Content Database is 0

This happens when the powershell script  that overwrites an already existing db from the bak file does not do it properly. In order to fix this, do the following


1. Dismount the Content Database from SharePoint
2. Remove the Content Database from SharePoint
3. Delete the messed up Content Database from SQL
4. Restore using the SQL UI
5. Mount the Content database into Sharepoint