However, when i attempt to do an in-place upgrade of SQL to 2008 R2, either 32 or 64 bit, it goes through the part where it checks the Setup Support Rules with no issues.

It's actually not a database compatibility issue because the backups always restore just fine if restoring from the direct network path and not via the DFS alias. I used backups taken from SQL ...