Implications of an incorrectly modified master database
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?
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!