In the process of re-branding my client, currently running on MOSS 2007. Can't detach their live database, so decided on backing up the live, and restoring the DB to a new database.

Live is called WSS_Content_Live

Restore is called WSS_Content_Restore

Problem here is, I created a new application in Central Administrator without a site collection as the restored database already has a collection assigned. Under databases, I removed the default created DB and attached the restored database.

I've done this 100's of times before, but for some reason, with this client the restored database returns zero "0" sites. after restored.

I've tried resetting IIS in the hopes that it's a delayed response between sql and sharepoint but not such luck?

[Update]

So, I'm thinking SQL. Did a bit of investigation with our IT guys and found this

[Update 2]

The process in the link did not work. Found a solution to fiddle with the [config_db] but this is not an option for me, as I'm on the live environment and the live site needs to be active during this process.