I was troubleshooting view pdf document via a web browser, and one of the steps I took to troubleshoot the issue was to detach and reattach the content database. I did this via the UI from central administration page and when I tried to open SharePoint site, I got 404 error.... So, I went to Central Admin site and verified that it show the correct number of sites, I even created a new site and the number of sites increased, but I could not browse to the newly created site (Note: the content is about 5 GB, which is fairly small).
What I did to fix the issue was to run PowerShell command to detach and reattach the content database as describe im
MS technet article:
To detach content database:
Dismount-SPContentDatabase ""
To attach content database:
Mount-SPContentDatabase "" -DatabaseServer "" -WebApplication http://SiteName
I am not sure why doing this action from Central Administration page created the issue in the first place, but from now on, I will start using PowerShell to administer SharePoint 2010.
