MS SQL Rebuild Master Database

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.
LVL 2
pironicAsked:
Who is Participating?
 
pironicConnect With a Mentor Author Commented:
did some digging and found this link... helped a lot.

http://geekswithblogs.net/mskoolaid/archive/2005/12/17/63413.aspx
0
 
Chris LuttrellSenior Database ArchitectCommented:
If the only thing you did was create new tables in master, then can you reverse the logic and just drop them.  If you did not drop or alter any of the system table in master then the rest of the databases should be ok.  The only other way I know of to restore the master database would be to restore from backups/transactions to the point in time before the script was run, but that could affect other databases.
0
 
pironicAuthor Commented:
The script (which was created by SQL management studio) droped the existing tables and then created the new ones. the old tables are not in the database anymore.
0
 
Chris LuttrellSenior Database ArchitectCommented:
Thanks for sharing what you found. This is good information to know.  Glad you found a fix.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.