So here is the situation. we created a database for backup on our development server. when we went to run the table create the tables from the creation script we had the master database selected and created the tables in the master database instead of the database we created.
my question is: how to we recreate the master database without loosing the data in the other databases that resides on the server?
We don't have any backups of this server, as this is part of the project that started this whole issue.