Restoring SharePoint sites, doesn’t!

So you’ve set up yourself a nice farm of production, testing and acceptance SharePoint servers, and you want to build a new test server.

You make a backup through the Central Administration website, and on your soon to be testing server, you restore the backup.

And then you want to connect the restored Content database, only to discover that SharePoint claims that this database does not contain any sites… Oops? …