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?