I have a Sharepoint Farm and I want a clone of it, under a different hostname (Preprod vs. prod).
We setup the Preprod farm from scratch, with new Web Applications. We then restored a backup of the WSS_Content database and attached it using Central Admin.
When browsing the main site collection (/), I get a HTTP 404 not found. If i go into Central Admin and View All Site Collections, I don't even get the box that has the URL, Title, Description etc. fields. When trying to get to it from PowerShell using Get-SPSite and site.OpenWeb(), it's not returning a site.
Other site collections work fine though, and there is nothing obvious in the logs, so I really don't know where the 404 comes from and how to troubleshoot it.