PDF documents won't open in web browser even after changing Browser File Handling to permissive in SharePoint 2010 Central Admin

Today I have opened a case with Microsoft SharePoint Support Team in regard to an issue where clicking on a PDF document would not open in a web browser instead it will give the following options:

Before calling Microsoft, I have tried iisreset, rebooted the servers, ran the configuration wizard, and dismounted and re-mounted the database to no avail.

To make the long story short the support technician informed me that  since the document libraries got created via a template my only option is to re-create the document libraries. Also, he informed me that there might be a fix either via Service Pack or SharePoint updates.

404 Error after detaching and reattaching database content in SharePoint 2010

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.