Implications of an incorrectly modified master database
Posted on 2011-10-11
I was recently given a sql script to setup a database on my sql server. The owner of the script didn't mention that I needed to create a blank db named 'xdb' before running the script.
I ran the script, and it seems to modify the master db, as there was no xdb.
Now, my master db consists of all kinds of tables and views that should be in xdb.
What are the implications? I know that master is required to start sql, so should I restore from backup right away?