master database


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

avatar image

7 2 2 3

(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

avatar image

Grant Fritchey ♦♦
137k 20 46 81

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 ♦♦
(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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Jun 22, 2010 at 08:19 AM

Seen: 1346 times

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

Copyright 2018 Redgate Software. Privacy Policy