question

hima avatar image
hima asked

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.

system-databasesmaster
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered

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.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
What's Brent Ozar have to do with it... Oh, you mean the database, yeah, I do agree.
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.