I'm a sys admin and by no means a developer so be kind.

We set up a Dev WSS site with three virtual sites all of which had it's own context databases, on a Dev SQL Server.

So the time comes along to move the Databases into production so I follow the Technet articles on doing so, basically it's a detach, move the DB's and then attach. All databases moved.

I then go into the sharepoint central administrator and Make the changes. Reset the Configuration Database Server, then Set the default content database Server, then I opened each of the virtual servers and set the content databases to the new server. Reset the app pools and reset IIS.

Only 1 of the sites works, the other two give me:

The Web site that is referenced here is not in the configuration database
But when I look at the sites table in the sts_config DB I see them all listed.