• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

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?
2 Solutions

adding tables to master DB wont effect it,

just go in a delete them

you will find them under master as normal tables
Below select query will give list all the tables, store procedures, functions, constraints

select * from sys.objects where is_ms_shipped =0

Open in new window

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.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

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!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now