x

master database

Hi,

I am creating a web site portal which pulls data from tables in SQL Server. Only 5-6 tables are required to be created. Can we create those tables in a master database of SQL Server or should i create a separate database. Because i heard that using master database might for such purposes may pose problems.

Kindly help me in this.

Thanks in advance.

more ▼

asked Jun 22, 2010 at 08:19 AM in Default

hima gravatar image

hima
7 2 2 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Create your own database and maintain it seperately. The master database is a system database maintained by Microsoft and subject to change as service packs and bug fixes come out. You should not place your own critical information inside that database or you could come into a situation where you could lose it.

Also, giving people access to the master database could give them access to certain controls on your server, again, a dangerous thing to do.

By and large you should not mess with msdb, tempdb or the master database. You should get backups in place for msdb and master. You can manipulate the model database, by design. Changes to it, objects placed inside of it, automatically are created when you create a new database.

more ▼

answered Jun 22, 2010 at 08:36 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

+1 - "Dont mess with Master"
Jun 22, 2010 at 09:35 AM Fatherjack ♦♦
What's Brent Ozar have to do with it... Oh, you mean the database, yeah, I do agree.
Jun 22, 2010 at 09:42 AM Grant Fritchey ♦♦
@Grant - very good answer, covering everything that is needed to know why it is not a good idea to step on the master's blue suede shoes.
Jun 22, 2010 at 01:01 PM Oleg
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x19
x13

asked: Jun 22, 2010 at 08:19 AM

Seen: 1163 times

Last Updated: Jun 22, 2010 at 09:11 AM